Forum Discussion
Solved
Looking to Sum multiple rows that match dates
Hello I'm, looking to sum all the values below on a specific date. It's easy enough to get the date in that is field and it's easy to make searchable. Such as Enter Date, let's make ...
A 365 solution:
=LET(stack,HSTACK(B1:E8,B10:E17,B19:E26),filtered,FILTER(DROP(stack,1),TAKE(stack,1)=H9),SUM(filtered))
A 365 solution:
=LET(stack,HSTACK(B1:E8,B10:E17,B19:E26),filtered,FILTER(DROP(stack,1),TAKE(stack,1)=H9),SUM(filtered))- This looks to be what I am looking for thank you!
- Glad the solution fit your needs. It helps to have up-to-date software!
