Calculating Weekend Allowance
Hi all,
I'm stuck with a calculation on weekend allowance. Workers would be paid a set allowance if they have worked on Sundays.
I have a spreadsheet set up to calculate the payment for an entire month. The dates lie on D2:AH2 and the number of hours worked per person are directly below, (e.g. D6:AH6,D7:AH7, etc). The number of hours worked would show 'A' if the person if absent.
To calculate the number of Sundays worked, I have tried SUMPRODUCT(--(D6:AH6>0),--(WEEKDAY($D$2:$AH$2)=1)), but it seems to give me 4 every time. Any ideas?
|