Formula to count the number of sessions completed dates per month includes varying months.

Options

I have a column on my spreadsheet that tracks the dates of all sessions that have completed. I am trying to figure the formula to tell me how sessions many were completed by month. I am super new to formulas. I really think I am over complicating it.

I have started a calculation sheet and have the months listed by column as such:

Jan

Feb

March

April etc.....

I want to tie these back to a Dashboard.

Any assistance would be so helpful...

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Options

    Hi @Aimee E. ,

    In the sheet to count completed sessions create columns with Month, Month# (and if using multiple years of data, a column for Year) to end up with something like this:


    If you're using a single year of data, then the count can be done with the following formula:

    =COUNTIFS({Sessions Range 1}, IFERROR(MONTH(@cell), 0) = [Month#]@row)

    Where your {Sessions Range 1} would be looking at the column containing your completed dates, such as this:

    If you want data spread over multiple years, you can use the below formula instead:

    =COUNTIFS({Sessions Range 1}, IFERROR(MONTH(@cell), 0) = [Month#]@row, {Sessions Range 1}, IFERROR(YEAR(@cell), 0) = Year@row)

    This will count up matches by both month & year. Example showing both (using the data shown above):

    You can then use a Row Report for the data for a dashboard etc.

    Hope this helps - if you've any questions just ask!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!