How to sum values based on criteria in another column in Excel

[DanDBZ]

Hi,

I am wondering if there is an easy conditioning format to have a cell sum all the rows of a column that contain a certain date in the column next to it?

Dan

 

[Jonmo1]

Ok, so you can use sumifS

Try this for July 2017, summing column A for dates in column B in July 2017

=SUMIFS(A:A,B:B,">="&DATE(2017,7,1),B:B,"<="&DATE(2017,7,31))

 

[FDibbins]

Use SUMIF()...
=SUMIF(date-range, date, sum-range)
date can either be hard coded or put into its own cell (preferred) and then referenced.

If you want to sum between 2 dates, change to sumifS()...
=sumifs(sum-range, date-range, ">="&start-date, date-range, "<="& end date()
again, the start date and end date are better referenced, than hard coded[/QUOTE]

Perhaps my 2nd suggestion will work for you, as long as your dates are real dates (try Jonmo1's test)
If it is just text dates (month names), then SUMIF with July should work

 

[DanDBZ]

HiJonMo,

that worked a treat, thanking you very much.

I appreciate your help including FDibbins.

 

[FDibbins]

Glad you got it resolved

 

[Jonmo1]

You're welcome.