Sum gives #Value! in Cell

  • 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!