Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using COUNTIF or SUMIF to evaluate a date range
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:
So to the right of each date, I want the sum of all dates that are in "January" that are in Column A.