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:

    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!