meeting two SUMIF criteria in one formula

  • Thread starter Thread starter Emily
  • Start date Start date
E

Emily

Is it possible to add amounts based on TWO SUMIF criteria?
I know how to add up amounts that meet a single criteria
but can't figure out how to nest the formula so it will
meet the first criteria, then meet the second criteria,
and add only those cells that meet both. Help!!
 
I don't think SUMPRODUCT will do it since I am not
multiplying anything. I want Excel to select those rows
where column B=1, then select those rows where column I =
BL, then sum up the matching entries in column K. ??
Click to expand...

Why not just try Don's formula. Who knows, you might just find out he knows what
he's talking about (he most definitely does in this case). It's not possible to
use multiple criteria in SUMIF or COUNTIF. SUMPRODUCT has become the standard
work-around, whether or not you happen to believe it works.

Fitting Don's formula more closely to your specs,

=SUMPRODUCT((Bx:By=1)*(Ix:Iy=BLx:BLy)*Kx:Ky)

where x and y are placeholders for topmost and bottommost rows in the range of
interest.
 
Back
Top