Do I need COUNTIF? Pivot Table? I forget

**jpaxton** · 01-05-2012, 04:32 PM

I have seen this done before and can't remember for the life of me how. For a multi-office inventory, I am trying to find the number of instances that an item occurs and then sum the total that appears in the column next to said item. For example in my picture below you notice that everyone has but one desk, of course, but some people have more than one monitor. (For reference sake let's call them Columns A & B) In order to create a second spreadsheet that is an company-wide item total (not total per office) I tried to use a COUNTIF function and only got the number of occurrances that "Monitor" occurred - not the total of monitors in the cell next to all instances of "Monitor" I would like to avoid using a multi-cell SUM formula in which I have to do all the hunting for instances of "Monitor" and input the cell data from the Qty field.

Can anyone help refresh my memory?

Thanks

pic1.JPG

**scottylad2** · 01-05-2012, 04:59 PM

change your countif for a sumif, but you would need to be suming along the lines of this and your answer would be in say C1 =SUMIF(A1:20,"monitor",B1:20)

you can either hardcode the word into the cell or type the word in a cell and reference that