Consulting

Results 1 to 3 of 3

Thread: Div/0! Question

  1. #1

    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.


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


  2. #2
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Hi, and welcome to the board!!


    Try changing this ..

    gr!M24
    to this ..

    MAX(1,gr!M24)

    HTH (Hope This Helps)

  3. #3
    Worked great!

    Thank you very much for your quick response.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •