Forum Discussion
SUM Function Not Working
I have a spreadsheet that I created a nested if statement to fill in a number value in cell J2 "=IF(G2="L","0",IF(G2="OTL","1",IF(G2="W","2",IF(G2="",""))))" it works fine and puts the proper numbe...
Hi there - I have a similar problem as your previous poster, but have checked my cells and no text fields there, but I still get $0 for the sub-total. I've done this many times and no problem, but just can't seem to pinpoint where the issue is. I've put a red box around the culprit - hope you can help.
Regards,
Teresa
It is not clear which cell you are referring to but your spreadsheet has a circular reference in AL4:AL8. That may be the cause.