sumif text

  1. L

    SUMIF not working

    Hi, I have a very simple formula: =SUMIF(C49:C58,"James",A49:A58) 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...
  2. C

    SUMIF Formula with Text

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

Some videos you may like

This Week's Hot Topics