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

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

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

Try this:

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

where D1 contains the date you are interested in.

Hope this helps.

Pete

On Aug 13, 4:51*pm, Dhardy wrote:
I need to have Excel sum data in column “M” if data in column “A” is a
certain date. Any tips/advice?

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

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

If this post helps click Yes
---------------
Jacob Skaria


"Dhardy" wrote:

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