I have a sheet that contains 3 columns for each day of the week.
Hours, Code # (10-636), Category (ABC)
I need weekly sums of the total hours by category and a weekly sum of hours by code #.
This formula works for the latter
=SUMPRODUCT(--(F9:A28=10),--B9:AT28
but if I try to input a letter in the category column it gives a value error.
I have been trying variations of this for 3 days with no luck, any advice would be greatly appreciated.

Thank you,