Summing based on 2 criteria

  • Thread starter Thread starter cubsfan
  • Start date Start date
C

cubsfan

I am trying to get a cell to sum based on 2 different ranges. Example,
have one column called status (which has a range of 0-5) and one calle
Type (which is based on SF, Acres, and Units). I've also got a 3r
column that is called size and it contains only numeric values tha
need to be summed up.

I was trying to figure out how I could create a formula that is able t
search all of the 1s in the first column and match it up with all of th
"Acres" in the other column and give me a total summed up value based o
a third numeric column
 
=SUMPRODUCT(--(A2:A200=1),--(B2:B200="Acres"),C2:C200)

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top