How to sum time depending on the day of the week

[Excelski]

Hi,

I have been trying with little success to sum the hours expended on each day of the week within a range

Any help as always greatly appreciated!

Kevin

[benishiryo]

hi kevin. you did not input the desired answers you wish you see. i am guessing in cell E3:
=SUMPRODUCT((WEEKDAY($A$1:$A$27)=ROWS($E$3:E3))*$B$1:$B$27)

i used ROWS to represent 1 to 7 based on your day sequence (sun = 1, Mon = 2, etc). you can also use this for Sunday:
=SUMPRODUCT((WEEKDAY($A$1:$A$27)=1)*$B$1:$B$27)

or if it's not in sequence:

Please Login or Register  to view this content.

[Excelski]

Hi benishiryo,

Sorry forgot to add desired results, I used =SUMPRODUCT((WEEKDAY($A$1:$A$27)=MATCH(D3,{"Sunday";"Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday"},0))*$B$1:$B$27)
and it works great

Thanks
Kevin