Sum gives #Value! in Cell

skamat · Aug 3rd 2015

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

**rory** · Aug 3rd 2015

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),"")

skamat · Aug 3rd 2015

Re: Sum gives #Value! in Cell

Thank you very much Sir

Sum gives #Value! in Cell

Participate now!

Share