Sumproduct if

F

frank

I want a worksheet to perform a SUMPRODUCT but only if the
rows fall between certain dates. please help. please
help!

thank you
 
R

Ron de Bruin

=SUMPRODUCT((B1:B10>=DATE(2003,1,12))*((B1:B10<=DATE(2003,7,18)))*C1:C10)

This will sum the cells in C if the date is between the two dates in the formula
 
Top