Formula

Copper Contributor
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
2 Replies

@NMGIBBS1976 

Hi

would you please share sample data in Excel?

Nabil Mourad

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.