Using COUNTIF or SUMIF to evaluate a date range

michael.dilios15206

Hi, so I have a ColumnA that has random dates for the current year 2017.  The column is formatted as a "Date" style column.

My goal is to sum each date in this ColumnA by Month:

Example:

So to the right of each date, I want the sum of all dates that are in "January" that are in Column A.  

 

Thanks

 

 

 

 

Adam Overton

I have some previous answers, so these are based on that. For an arbitrary date range, the formula looks something like this:

=SUMIF([Due Date]1:[Due Date]6, AND(@cell >= DATE(2017, 4, 1), @cell < DATE(2017, 5, 1)), Cost1:Cost6)

Note that DATE(2017,4,1) could be substituted for a reference to a start date cell.

Similarly for the end date.

For month by month like you actually asked, you can do something like this:

=SUMIF([Due Date]1:[Due Date]6, AND(MONTH(@cell) = 4, YEAR(@cell) = 2017), Cost1:Cost6)

You can see I check for MONTH(@cell) = 4, and that just means April of course. If you had this refer to a month number in another column, you could fill this down and get what you want.