=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

"R" wrote in message
...
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.