conditioned sum

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi all,
I have a monthly time sheet which combined from 4 weeks.
each day their is time in, time out, total hours.
i want to sum all the hours that the person work on saterday only.
I tried sumif and dsum, but it didnt work - maybe because of me. :-)

Thanks a lot,

Tom
 
Hi Tom
if your dates are in column A and your total hours are in column D try
the following formula
=SUMPRODUCT(--(WEEKDAY(A1:A100,1)=7),D1:D100)
and format the target cell with the custom format
[hh]:mm
 
Back
Top