Calcuate totals based on specific criteria

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!
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arriving at totals 2
Sumproduct, 3 columns and date 3
Finding the right style field in VBA 0
Add values in "P" that fall between dates "03/01/00 and 03/31/00" 6
Totals Lookup by month and year 3
Deriving Exactly XXX Amount of Weekdays 3
match function with nested if 12
Sum or Average with #N/A cells 5

Top