vlookup I think...

[Korimint]

I am trying to add numbers in column 4 based on dates in February which are in column 1. I only want to add together the ones in February and then be able to do the next months to come.

So I have :
1/31/2011 4 1 300.00
2/1/2011 5 2 300.00
2/2/2011 6 2 200.00

All the way down to 2/28/2011, I want to sum up column 4 only from 2/1 - 2/28 but I don't understand how to add up the sum of a vlookup?

Thanks for looking and trying to help.

Kori

 

[scottylad2]

this is a small sample, the actual datas a couple of hundred rows.

Excel Workbook
	C	D	E	F	G
32	01/11/2010	13793		01/02/2011	28/02/2011
33	03/11/2010	11964
34	05/11/2010	13511		318,564.00
35	06/11/2010	5884		318,564.00
Sheet1

Excel 2010

Cell Formulas
Range	Formula
F34	=SUMPRODUCT(--(Dates>=F32),--(Dates<=G32),D32:D296)
F35	=SUM(D91:D124)

Excel Workbook
Name	Refers To
Dates	=Sheet1!$C$32:$C$296
Workbook Defined Names

I've added the sum in there just to let you see the sumproduct works

 

[Korimint]

Scotty,

All I get is a #value in the cell??

Any ideas on what I have wrong?

Kori