Sum gives #Value! in Cell

  • Please see attached book


    I have made a formula when all numbers are present the total is calculated in cell C25, but when no numbers are present the cell C25 displays #Value! error.


    I would like the cell to be blank when no numbers are present and calculate the total if numbers are mentioned in any cell between C3:C20

  • Re: Sum gives #Value! in Cell


    C21 is not blank - it's returning a zero length string and you can't subtract 0 from "". Change the formula in C25 to:
    =IF(C23-N(C21)<>0,C23-N(C21),"")

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!