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!...
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.