F frank Aug 8, 2003 #1 I want a worksheet to perform a SUMPRODUCT but only if the rows fall between certain dates. please help. please help! thank you
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 Aug 8, 2003 #2 =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
=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
