Forum Discussion
SUMIFS
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.
4 Replies
If with formulas
D12: =UNIQUE(A2:INDEX(A:A,COUNTA(A:A)-1)) E12: =SUMIFS(B2:B30,A2:A30,D12#,B2:B30,8.5)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.
mkeller37 You marked your follow-up question as "Best response", though I take it that you still need an answer.
Look into using a pivot table. It will allow you to create the summary you describe without complicated formulae. Attached is an example. If you are not familiar with pivot tables, you can find many resources and tutorials on-line.
- Thanks for the help, this worked great!
