Simple Sum Question

[Iknewthisguy]

So I've got a sum formula tha delivers 0. Everything is functionally sound, I've checked the formatting and everything seems fine. Please help.

Thanks.
Chris

 

[Sal Paradise]

Perhaps posting the formula would be useful? So that we could confirm that it's functionally sound? Perhaps?

 

[shemayisroel]

Ok could you post a copy of your formula?

I'd also check that the sum range is actually numbers and not text? Or even perhpas your sum range in a dump from a database and is not stored as a number?

 

[hardeep.kanwar]

Hey Try This

Select your range

Press CTRL+H

Find What- ALT+0160
Replace With - Blank

Hardeep kanwar