•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?
Our take
Navigating complex data can be challenging, especially when traditional methods fall short. If you're looking to sum row values based on two horizontal lookups, consider a formula that seamlessly integrates both conditions. For your scenario, where E59:S59 equals E111 and E60:S60 is less than E112, you can use a straightforward approach to achieve your goal. This will streamline your analysis, allowing you to bundle by phase effectively, despite the limitations of your timesheet system. Let's explore the optimal formula to simplify your workflow.
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]
Read on the original site
Open the publisher's page for the full experience
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