•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#automated anomaly detection
#Excel compatibility
#formula generator
#Excel alternatives
#cloud-based spreadsheet applications
#sum
#holiday funds
#formula
#Excel
#remaining balance
#lookup
#year
#range of cells
#automatically calculate
#SUMIF