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
Bookmarks