Sum with Formulas

Copper Contributor

I have columns that have returned a value based on formulas. However, I can't sum the column - Excel returns a zero. Is there a workaround?

7 Replies

@Regina5 

Depends on what formulas return. If texts, SUM ignores them. If texts which looks like numbers, you may converts them to numbers modifying formulas a bit.

@Regina5 

Without a file, knowing the Excel version, operating system and storage medium can only be guessed at. I'm not here to guess, but I'll try anyway.

Help to be helped. Helping people to help themselves.

Guess:

One possibility is that the numbers are text.

Second assumption it is due to the circular reference.

Iteration might be off. As I said, everything without grant.

 

Finally, here is a link with information on how you can get a quick and precise solution proposal.

Welcome to your Excel discussion space!

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

@NikolinoDE I uploaded the file into Google sheets because I don't see where to include the file. I am trying to sum the columns J forward.

@Regina5 

Access denied

image.png

@Sergei Baklan - darn, try again please.

@Regina5 

Thank you, it works now. Not sure what you'd like to sum, but here 

image.png

you have texts, not numbers. Perhaps formula shall be

instead of
=IF($R3="Dues - Land","$200",IF($R3="Dues - PT Residential","$300",IF($R3="Dues - FT Residential","$400","")))

to
=IF($R3="Dues - Land",200,IF($R3="Dues - PT Residential",300,IF($R3="Dues - FT Residential",400,"")))

and result formatted as currency.

Thank you - I am trying to sum columns t forward for what was received.