Hi Excel Experts,
I'm trying to find an alternative to SUMIFs for the below problem. I am trying to summarize the following: Person A is listed on multiple rows, the project identifier is in a column, and the number of hours by each month are in a column. Sumifs easily solves this but is now bogging down.
Is there an alternative to sumifs in this scenario? I've researched SUM(Filter , maybe a nested Xlookup summation, or DSUM.
From ChatGPT - For Example
Month Project Person Hours Jan A John 10 Jan B John 5 Jan A Jane 8 Feb A John 12 Feb B Jane 15Create a formula to calculate the total hours worked by a specific person on a specific project for a given month.