1. ## sumif (2000)

Easy one: Could someone help me with the formula that will sum the products of 2 cells if the criteria of a thir cell is met? For example, assume Column A, Rows 1-10 contain supplier names (there are duplicates); Column B, Rows 1-10 contain the number of inventory parts purchased from the supplier, and Column C, Rows 1-10, the price of the part. I would like to sum the total cost of the inventory (i. e., number of inventory parts multiplied by the price) I have purchased, say, from Supplier "Jones", who, again, may be in several of the cells in Column A, Rows 1-10.

2. ## Re: sumif (2000)

The following formula should be entered as an array formula, i.e. confirm with Shift+Ctrl+Enter:

=SUM(B1:B10*C1:C10*(A1:A10="Jones"))

3. ## Re: sumif (2000)

=SUMPRODUCT((A1:A10="Jones")*B1:B10,C1:C10)
will do it without the need to be entered as an "array" (no need for ctrl-shift-enter)

Steve

4. ## Re: sumif (2000)

Yep, thanks. So will

=SUMPRODUCT((A1:A10="Jones")*B1:B10*C1:C10)

Jeff can choose which one he likes best <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

5. ## Re: sumif (2000)

Thanks to all-so many to choose from; just like Christmas morning!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•