•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Index Match or Xlookup to return sum of row values based on matching two horizontal lookups?
Ask: If E59:S59=E111 AND E60:s:60<-E112, give me the sum of E61:71,else return 0
What is the smoothest formula for this?
I added in what I'm trying to do on the formula line. ChatGPT is less helpful with this than I am. I want to bundle by phase because our timesheet system doesn't allow me to pull a report by phase/task, only by person. I tried Xlookup but kept getting SPILL errors so I am at a loss. FTE1 is a different category and should not be included (PM, I can plug that as it's always in the same position). Thanks in advance for your help.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#formula generator
#rows.com
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#row zero
#cloud-based spreadsheet applications
#Index Match
#Xlookup
#formula
#sum
#E59:S59
#E111
#E60:s:60
#E112
#E61:71