Summing based on 2 criteria

[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

 

[Guest]

There is a very powerful tool called SUMPRODUCT() that can help you. There
is also a really good explanation at:

http://www.contextures.com/xlFunctions01.html#SumProduct

 

[Bob Phillips]

=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)