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 number in J2. It does this for cells G2:G83. The number value goes into cells J2:J83. I then used the SUM function to total the numbers in cells J2:J83 however, the sum shows as 0 instead of the actual sum. What if anything am I missing?
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.