Forum Discussion
Formula
Hi there
Is there someone that can help me with a rota spreadsheet and calculating the number of hours a day (over a month) please?
I have a formula
=SUMPRODUCT(($B7:$B35=ShiftNames)*(Shifts!$D$3:$D$27))
but it's faulting somewhere in the formula, I can't figure it out
I can send a screenshot of what the rota looks like or if easier I can send over a copy of the rota???
Thanks in advance
Natasha
Is there someone that can help me with a rota spreadsheet and calculating the number of hours a day (over a month) please?
I have a formula
=SUMPRODUCT(($B7:$B35=ShiftNames)*(Shifts!$D$3:$D$27))
but it's faulting somewhere in the formula, I can't figure it out
I can send a screenshot of what the rota looks like or if easier I can send over a copy of the rota???
Thanks in advance
Natasha
2 Replies
- Hi Natasha, SUMPRODUCT requires vectors (a column or a row of data) to be of equal size. B7:B35 has 29 cells; D3:D27 has 25 cells. It will spit the dummy. Please make your column references of equal length.
