software

I have a work sheet that contains a variety of columns. Three columns are of
interest. The first, say A, contains years (2006, 2005, 2004 etc.). The
second column, B, contains Names (Jim, Dick, Bob etc.). The third column, C,
contains a numbers. What I need to do, but I'm having problems figuring it
out is, I want to add the values of column C that meet the criteria of each
column A and B. For example I want to add all the values of C that are 2006
(column A) AND Jim (column B).

I've been playing around with formulas but I haven't managed to figure it
out with trying to match the two columns. If anyone could help or has any
ideas I would appreciate any direction I could get.

Thank you in advance.

=SUMPRODUCT(--($A$3:$A$15=$A1),--($B$3:$B$15=B$1),$C$3:$C$15)
enter 2006 in cell a1 and Jim in cell b1
note the area's need to be sized the same i.e. 3 to 15 for this example.

--
Greetings from New Zealand
Bill K

quot;Rquot; gt; wrote in message
...
gt;I have a work sheet that contains a variety of columns. Three columns are
gt;of
gt; interest. The first, say A, contains years (2006, 2005, 2004 etc.). The
gt; second column, B, contains Names (Jim, Dick, Bob etc.). The third column,
gt; C,
gt; contains a numbers. What I need to do, but I'm having problems figuring
gt; it
gt; out is, I want to add the values of column C that meet the criteria of
gt; each
gt; column A and B. For example I want to add all the values of C that are
gt; 2006
gt; (column A) AND Jim (column B).
gt;
gt; I've been playing around with formulas but I haven't managed to figure it
gt; out with trying to match the two columns. If anyone could help or has any
gt; ideas I would appreciate any direction I could get.
gt;
gt; Thank you in advance.
Use the sumproduct function. This acts like the SUMIF function, but uses two
qualifiers.

=SUMPRODUCT(--(A1:A3=2005),--(B1:B3=quot;Jimquot;),C1:C3)

quot;Rquot; wrote:

gt; I have a work sheet that contains a variety of columns. Three columns are of
gt; interest. The first, say A, contains years (2006, 2005, 2004 etc.). The
gt; second column, B, contains Names (Jim, Dick, Bob etc.). The third column, C,
gt; contains a numbers. What I need to do, but I'm having problems figuring it
gt; out is, I want to add the values of column C that meet the criteria of each
gt; column A and B. For example I want to add all the values of C that are 2006
gt; (column A) AND Jim (column B).
gt;
gt; I've been playing around with formulas but I haven't managed to figure it
gt; out with trying to match the two columns. If anyone could help or has any
gt; ideas I would appreciate any direction I could get.
gt;
gt; Thank you in advance.


You need this:

=SUMPRODUCT(--(A1:A100=2006),--(B1:B100=quot;Jimquot;)*C1:C100)

Replace the 2006 with a cell containing that search value
and do the same with quot;Jimquot;--
Cutter
------------------------------------------------------------------------
Cutter's Profile: www.excelforum.com/member.php...foamp;userid=9848
View this thread: www.excelforum.com/showthread...hreadid=498447