software

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

I was trying to figure out how I could create a formula that is able to
search all of the 1s in the first column and match it up with all of the
quot;Acresquot; in the other column and give me a total summed up value based on
a third numeric column.--
cubsfan
------------------------------------------------------------------------
cubsfan's Profile: www.excelforum.com/member.php...oamp;userid=33272
View this thread: www.excelforum.com/showthread...hreadid=534598There is a very powerful tool called SUMPRODUCT() that can help you. There
is also a really good explanation at:

www.contextures.com/xlFunctio...tml#SumProduct
--
Gary's Studentquot;cubsfanquot; wrote:

gt;
gt; I am trying to get a cell to sum based on 2 different ranges. Example, I
gt; have one column called status (which has a range of 0-5) and one called
gt; Type (which is based on SF, Acres, and Units). I've also got a 3rd
gt; column that is called size and it contains only numeric values that
gt; need to be summed up.
gt;
gt; I was trying to figure out how I could create a formula that is able to
gt; search all of the 1s in the first column and match it up with all of the
gt; quot;Acresquot; in the other column and give me a total summed up value based on
gt; a third numeric column.
gt;
gt;
gt; --
gt; cubsfan
gt; ------------------------------------------------------------------------
gt; cubsfan's Profile: www.excelforum.com/member.php...oamp;userid=33272
gt; View this thread: www.excelforum.com/showthread...hreadid=534598
gt;
gt;

=SUMPRODUCT(--(A2:A200=1),--(B2:B200=quot;Acresquot;),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)

quot;cubsfanquot; gt; wrote in
message ...
gt;
gt; I am trying to get a cell to sum based on 2 different ranges. Example, I
gt; have one column called status (which has a range of 0-5) and one called
gt; Type (which is based on SF, Acres, and Units). I've also got a 3rd
gt; column that is called size and it contains only numeric values that
gt; need to be summed up.
gt;
gt; I was trying to figure out how I could create a formula that is able to
gt; search all of the 1s in the first column and match it up with all of the
gt; quot;Acresquot; in the other column and give me a total summed up value based on
gt; a third numeric column.
gt;
gt;
gt; --
gt; cubsfan
gt; ------------------------------------------------------------------------
gt; cubsfan's Profile:
www.excelforum.com/member.php...oamp;userid=33272
gt; View this thread: www.excelforum.com/showthread...hreadid=534598
gt;