View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
for example
=SUMIF(A1:A100,"=" & DATE(2004,10,1),B1:B100)

"Lius" wrote:

How do I add up a range of cells using dates as a criteria?