That was my original thought, until I read it properly <vbg
=SUMPRODUCT(--(Sheet2!$B$1:$B$1000=Sheet1!A1),--(Sheet2!A1:A100=DATE(2006,1
,1)),Sheet2!C1:C1000)
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)
"adscrim" wrote in
message ...
What if the date reference is in a range. Should have mentioned this in
the original posts.
on sheet 1 I have a list of names in column A and a SUMIF in column B.
The SUMIF looks at column B on sheet 2 for the range, the name in
column A on sheet 1 for the criteria and column C on sheet 2 for the
sum range.
Column A on sheet 2 has a list of dates which I want to incorporate
into the SUMIF function so that the values in column C sheet2 are
summed where the name in column b sheet2 equals the name picked from
the list in A sheet 1 but only when the date in column A sheet 2 is
above a certain value.
Hope thats clear enough and thank for the early suggestion Bob
--
adscrim
------------------------------------------------------------------------
adscrim's Profile:
http://www.excelforum.com/member.php...o&userid=30636
View this thread: http://www.excelforum.com/showthread...hreadid=502907