Sum Weekdays and sum Weekend

[usl]

I have a sheet with alle days an date in one month

in column "A" the date (format: TTTT TT.MM.JJ)
in column "B" I have the worked hours

Below in the sheet I would to have to sums
each one for weekdays and weekends,

because my guys get more money if they work on a saturday or sunday.

I have been playing with the formulars
=sumif(weekdays(....., but cant geht the right thing

Have any of you got a good solution to this ?

Thanks
Uli

 

[Isa Cole]

To add up based on Monday - Friday:

=SUMPRODUCT((WEEKDAY($A$1:$A$50,1)<6)^1,$B$1:$B$50)

For Weekends:

=SUM($B$1:$B$50) less the result of the above formula.

Regards
Jon

Many thanks for this. It works a treat. The problem is I don't understand how it is working? What does the "^1" bit actually do? I have looked through the rest of the thread but I still don't understand it. I'm confident with a lot of formulae but this is the first time in using sumproduct.

Cheers