CountIfs- How many of one name in a date range

amanda_d

I have - 

a column containing start dates, that spans 2019

a column containing an assortment of names that re-occur on a random basis.

I want to count how many times each name occurs each month.

Any help appreciated!

Andrée Starå

Hi Amanda,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Try something along the lines of...

 

=COUNTIFS([Name Column]:[Name Column], "Name", [Date Column]:[Date Column], IFERROR(MONTH(@cell), 0) = ##)

 

Replace the column names with yours and replace the ## with the appropriate month number, and this should work.

amanda_d

Thank you!

Paul Newcome

Happy to help.