Thanks for the help, I wish I would have used discussion groups earlier,
would have saved me much time.

"Biff" wrote:

Hi!

Try one of these:

Enter the criteria in cells:

G1 = 2/15/2006
H1 = 7/8/2006
I1 = 1

=SUMPRODUCT(--(A1:A8=G1),--(A1:A8<=H1),--(B1:B8=I1),C1:C8)

Or, with the criteria hardcoded in the formula:

=SUMPRODUCT(--(A1:A8=DATE(2006,2,15)),--(A1:A8<=DATE(2006,7,8)),--(B1:B8=1),C1:C8)

=SUMPRODUCT(--(A1:A8=--"2006/2/15"),--(A1:A8<=--"2006/7/8"),--(B1:B8=1),C1:C8)

Biff

"jrheinschm" wrote in message
...
A B C D E
1 1/21 1 10
2 2/15 2 5
3 3/24 1 10
4 4/15 2 20
5 5/18 1 10
6 6/10 1 10
7 7/8 1 5
8 8/12 2 5
9
Search for sum of column C if column B = 1 between the dates of 2/15 -
7/8:
=35
Probably another simple solution for this one. Thanks for the help.