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?
|