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

[Dhardy]

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

 

[Pete_UK]

Try this:

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

where D1 contains the date you are interested in.

Hope this helps.

Pete

 

[Jacob Skaria]

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

If this post helps click Yes