Try one of these...

Use cells to hold your criteria:

G2 = start date
H2 = end date
I2 = 309

=SUMPRODUCT(--(A2:A8=G2),--(A2:A8<=H2),--(B2:B8=I2),E2:E8)

If you're using Excel 2007:

=SUMIFS(E2:E8,A2:A8,"="&G2,A2:A8,"<="&H2,B2:B8,I2 )

--
Biff
Microsoft Excel MVP


"Art" wrote in message
...
A B E
2 01/11/2009 214 $140,000
3 01/25/2009 309 $40,000
4 03/03/2009 309 $200,000
5 03/15/2009 214 $10,000
6 03/21/2009 309 $300,000
7 03/25/2009 309 $120,000
8 04/15/2009 309 $150,000

Hello,

I am hoping someone is able to help me with this issue. I am attempting to
sum the values in a column, "E" when the date in column, "A" falls between
03/01/2009 and 03/31/2009, and the number in column "B" is equal to "309".
Using the data above the formula should only add rows, 4, 6, & 7 for a
total
of
$620,000. I have had a time of it trying to figure out how to create a to
do
this. Can anyone please assit?
--
Art
Los Angeles, California