May 17 2022 09:45 AM
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?
May 17 2022 10:03 AM
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.
May 17 2022 10:10 AM
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.
I know I don't know anything (Socrates)
May 17 2022 10:18 AM
@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.
May 17 2022 12:20 PM
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.
May 17 2022 01:45 PM