•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
#rows.com