SUMIF and IF Functions on Range(s)

  • Thread starter Thread starter Ben Knox
  • Start date Start date
B

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
 
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
 
Back
Top