Div/0! Question

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.

Code:

---

=SUMPRODUCT((gr!$A$2:$A$26=$A24)*(gr!$B$2:$B$26=B$1)*($CZ24=1)*($D24/gr!M24))

---

Thanks in advance

:banghead:

Hi, and welcome to the board!!


Try changing this ..

Code:

---

gr!M24

---

to this ..

Code:

---

MAX(1,gr!M24)

---

HTH (Hope This Helps)

Worked great!

Thank you very much for your quick response.