I followed the SUMIF formula exactly - even used the same one from an old workbook where it worked for me. It didn't apply to the new workbook and returned everything as 0. I made sure the number columns were saved as number in the toolbar, and that the text was labeled as text (also tried general) - didn't change much.
So I made a whole new workbook with sample data just to see if I could get it to work at all. The numbers are 1, 2, 3 and the word is Good. Everything that says Good should be added into a third cell.
Can anyone take a look at my sample workbook (called SUMIF) that's been uploaded and share what I'm doing wrong with the SUMIF to return 0? I've been trying to solve this seemingly simple problem for weeks now. =/
Bookmarks