SUMIF and IF Functions on Range(s)

[Ben Knox]

Here is my problem. I am trying to sum the values of a
given column up based on a given set of conditions. For
example, I want to sum up the prices of a given product
if the product was made by a particular company, is a
particular size, and cost less than a specified amount.
The sumif function would work wonders if it allowed you
to test multiple conditions, but since it only allows one
it appears to be useless. I tried embedding if
statements testing on a given range of cells, but unless
the first value in the resulting array is true it always
comes back with false. Does anyone have any suggestions.

Thanks,
Ben

 

[Frank Kabel]

Hi
use SUMPRODUCT instead. e.g.
=SUMPRODUCT((A1:A100="product_name)*(B1:B100="type"),C1:C100)
sums the values of C1:C100 if the conditions in column A AND B are met