Forum Discussion
Solved
SUMIFS
I’m needing to build a formula that’s able to sum multiple cells that have the same value in them for multiple specific dates, and each date is repeated multiple times in multiple cells. The formula n...
This a picture of my excel spreadsheet that I'm trying to build the formula for that can sum multiple cells that have the same value in them (8.5), but for each separate date. So I need to know the total amount of hours that were worked on August 21, 2019, but only for people who worked 8.5 hours on that date. The formula will need to be able to work for the dates following August 21st as well, and so on.
If with formulas
D12:
=UNIQUE(A2:INDEX(A:A,COUNTA(A:A)-1))
E12:
=SUMIFS(B2:B30,A2:A30,D12#,B2:B30,8.5)