•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Index Match with SUMIF for duration or match for dates in between.
Hello,
I found a similar post to this but doesn't completely answer my needs.
I have a table that has a quantity data that's organized like a weekly calendar.
I want to create another table (A19:E26) that gets the total amount for the selected Duration Date (A22) & End (B22),Item Name (C22), and Location (D21) - result to display on D22. Respectively for Location (E21) - result to display on E22.
I was able to do an index match for specific single dates, but could not figure out how to do like a sumif for a duration.
Help!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#rows.com
#Excel compatibility
#Excel alternatives
#financial modeling with spreadsheets
#Index Match
#SUMIF
#Duration Date
#End Date