New Contributor

# Sum with Formulas

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

# Re: Sum with Formulas

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.

# Re: Sum with Formulas

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!

NikolinoDE

I know I don't know anything (Socrates)

# Re: Sum with Formulas

@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.

# Re: Sum with Formulas

@Sergei Baklan - darn, try again please.

# Re: Sum with Formulas

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

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.

# Re: Sum with Formulas

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