Hi all,
I'm having a bit of a problem with a sum product formula. Can anyone help? The formula i'm using keeps coming up with a div/0! error when the cell it refers to is blank. Everything I've tried doesn't work. the formula is below, can anyone tell me what I'm missing to make the div/0! go away.
Thanks in advance=SUMPRODUCT((gr!$A$2:$A$26=$A24)*(gr!$B$2:$B$26=B$1)*($CZ24=1)*($D24/gr!M24))