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