Sum data in 1 column based on date info in another column

D

Dhardy

I need to have Excel sum data in column “M†if data in column “A†is a
certain date. Any tips/advice?
 
P

Pete_UK

Try this:

=SUMIF(A:A,D1,M:M)

where D1 contains the date you are interested in.

Hope this helps.

Pete
 
J

Jacob Skaria

With dates in C1 and C2
=SUMPRODUCT(--(A1:A100>=C1),--(A1:A100<=D1),M1:M100)

If this post helps click Yes
 
Top