Summing With Criteria

[lumos]

I'm trying to create a spreadsheet with summing based on criteria and it's just not seeming to work. My spreadsheet is basically a calendar separated by month and day and within each day, the user has the option to enter a time digit (like 4) and a type (like PTO). I have the spreadsheet setup how I want it but the totals are not working as I would like. I have total columns setup and want to make some sort of formula that says total all those listed as PTO, total all those listed as Sick, etc. I tried SUMIF but it's giving me errors, I think because they are in the same rows. I have attached a small cutout version of my spreadsheet for reference and help. Any help would be so much appreciated! Attachment 445914

[ChemistB]

In B2 of Sheet2 copied down

=SUMPRODUCT(('2016'!$B$5:$AZ$9),--('2016'!$C$5:$BA$9=A2))

Does that work for you?

[daffodil11]

I went with the array formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

[lumos]

That one didn't work, I think because went too general & didn't reference the PTO. Thank you though.

[lumos]

YES!!!!! This worked beautifully!! Thank you so incredibly much!!!!

[ChemistB]

>>That one didn't work, I think because went too general & didn't reference the PTO

Yes, PTO was in A2. See attachment