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
 

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

Sum data if dates in a column are w/in a specific range 13
Need Help with a VBA subroutine 0
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
SUMIF evaluating blank DATE data 2
Getting Text data using the Data - Subtotal feature 1
Excel does not accept text format! 0
List all tables, including document structure 0
changing rows *and* columns in automatic formulae 1

Top