sum accounts between two given dates

E

excelFan

hi all,
how to sum from the list (myList) only the items that occured within two
given dates in cells A1 and A2
many thaks for the help
 
F

Frank Kabel

Hi
try
=SUMPRODUCT(--(B1:B100>=A1),--(B1:B100<=A2),C1:C100)
where column B stores your dates and column C the values to sum
 
Top