•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Sum of a range based on 2 different criteria?
Hello,
I'm working on a document which is a holiday funds to keep track of individual person's remaining balance to pay.
I want to use a formula to automatically calculate the sum of a range of cells which lie against a certain year under a person's name.
Below as an example:
As above, I want to look up Name 1 in 1:1, look up Year 1 in A:A and then return the sum of those numbers in that Year 1 range to give me my final result.
Is this possible?
I've tried all sorts of SUM, SUMIF, SUMIFS, XLOOKUP and combinations but can't seem to get it to work. I also don't want to have to manually select the cells for year SUM as this is constantly updating and want it to be automated.
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site