PDA

View Full Version : [SOLVED] Div/0! Question



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:

Zack Barresse
05-02-2005, 08:12 AM
Hi, and welcome to the board!!


Try changing this ..


gr!M24

to this ..


MAX(1,gr!M24)


HTH (Hope This Helps)

Roaddog
05-02-2005, 08:35 AM
Worked great!

Thank you very much for your quick response.