Use a Date range to sum a column

B

Bob

What is the formula to sum Column F (the price) if the date is between 1/1/04 and 1/31/04

Date Pric
1/1/04 1073 2-A Druid Hills John Willis Homes Roger Swims $18,000.0
2/2/04 1074 3-A Druid Hills John Willis Homes Roger Swims $18,000.0
1/1/04 1075
1/7/04 1076 29 Darthmouth John Willis Homes Kevin Aycock $21,000.0

Thank you for your help.
 
P

Peo Sjoblom

Looks like you are totaling per month

=SUMPRODUCT(--(MONTH($A$2:$A$200)=1),--($A$2:$A$200<>""),$F$2:$F$200)

if you really want to set the dates and it is not always first and last date
of the month

=SUMPRODUCT(--($A$2:$A$200>=DATE(2004,1,1)),--($A$2:$A$200<=DATE(2004,1,31))
,$F$2:$F$200)
 
Top