I have a very simple formula:
The values in Column A are being pulled from another sheet in the same workbook and are correct. I've checked for any errors (like extra spaces) in Column C. Instead of summing my results, I keep getting 0.
I tried pasting...
I have a list a store locations and their inventory of their freezers (how many). Column A lists the store locations, Column B lists their freezers.
I need a formula (I was thinking of using the SUMIF formula...but it doesn't work with text) in cell G1 that sums how many freezer doors for the...