Roaddog
05-02-2005, 08:10 AM
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.
=SUMPRODUCT((gr!$A$2:$A$26=$A24)*(gr!$B$2:$B$26=B$1)*($CZ24=1)*($D24/gr!M24))
Thanks in advance
:banghead:
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.
=SUMPRODUCT((gr!$A$2:$A$26=$A24)*(gr!$B$2:$B$26=B$1)*($CZ24=1)*($D24/gr!M24))
Thanks in advance
:banghead: