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