Prev: Weeknum in 2010 incorrect
Next: Locking Cells
From: Frank on 25 Jan 2010 08:00
first one didn't work second one did.
/!\ I had to replace "," into ";"

Below the working formula:
=SUMPRODUCT((WEEKDAY(A2:A32)>1)*(WEEKDAY(A2:A32)<7);B2:B32) (thanks to Jacob
Skaria)
alternative:
=SUMPRODUCT((WEEKDAY(A2:A32;3)<5)*1;(B2:B32)) (thanks to Mike H)

Dutch:
=SOMPRODUCT((WEEKDAG(A2:A32)>1)*(WEEKDAG(A2:A32)<7);B2:B32)
=SOMPRODUCT((WEEKDAG(A2:A32;3)<5)*1;(B2:B32))

 | 
Pages: 1
Prev: Weeknum in 2010 incorrect
Next: Locking Cells