Forum Discussion
SUM Function not working
I have several nested IF statements in cells b4:g4 that display different #'s based on the value of another cell. When I do =SUM(B4:G4), it displays 0. Is there a way I can fix this?
4 Replies
Quick solution:
Replace this:
SUM(B4:G4)
With this:
=SUMPRODUCT(--B4:G4)
Or this:
=SUMPRODUCT(VALUE(B4:G4))
please refer to my answer to this question to learn more about this issue.
Hi Marc,
Please be sure your cells are formatted as numbers, not text. You may check by =ISNUMBER(B4), etc.
I have the cells formatted as a number, but the ISNUMBER function reports false.
Without sample it's hard to say why do you have the text. As variant your IF could return text
