Calcuate totals based on specific criteria

  • Thread starter Thread starter Dhardy
  • Start date Start date
D

Dhardy

Hello,
I am trying to get Excel to add data in column "M" if the data in column "A"
is between 8/1/2009 & 8/8/2009. Can anyone help with this formula? Thanks in
advance!
 
With the query dates in C1 and D1 try the below formula...

=SUMPRODUCT(--(A1:A100>=C1),--(A1:A100<=D1),M1:M100)

If this post helps click Yes
 
Back
Top