Data

the simple formula

=sum(B:B) will add only numbers

What is the source of the #VALUE# error? My first thought would be to nest the current function in B so that it returns some kind of text string when it errors, then the sum function ImramBhatti suggested would work fine. Are you familiar with the IFERROR() function? https://support.office.com/en-us/art...6-63f3e417f611

Something like =IFERROR(current formula in B,"error")

Originally Posted by shamshersadiq

[deleted] sab..its not working because of #VALUE!.
thanks for letting me now that its a simple formula

This is inappropriate language. Further offenses will result in a ban.



Common courtesy is the order of the day. Avoid coarse language, personal attacks and inflammatory remarks. Address your concerns at topics and not at people.