sum accounts between two given dates

[Guest]

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

 

[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

 

[Guest]

many thanks Frank, your feedback was very helpful.