COUNTIF dates within the next year.

linda@uidp

Hi There! 



I'm new to formulas and have tried lots of different ways to solve this, and still haven't managed, so any assistance would be appreciated. I want to count each Event Type which starts within the next 365 days. 



I have managed to count the total number of each Event Type in the column by using:

=COUNTIF([Event Type]:[Event Type], "Networking Reception")

=COUNTIF([Event Type]:[Event Type], "LIstening Session")

but I need to narrow this number down to only those starting within the next year as indicated in the date column. 



I've tried using COUNTIF with the TODAY function, but I'm clearly doing something wrong as I keep getting the dreaded #UNPARSABLE result. 



A screenshot is attached for reference.



Please help! 



Best, 

Linda

 

Andrée Starå

Hi Linda,

Try something like this.

=COUNTIFS([Event Type]:[Event Type]; "Networking Reception"; Date:Date; >=TODAY(); Date:Date; <=TODAY(365))

The same version but with the below changes for your and others convenience.

=COUNTIFS([Event Type]:[Event Type], "Networking Reception", Date:Date, >=TODAY(), Date:Date, <=TODAY(365))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

linda@uidp

Hi Andrée, 



It's still not working. Could there be something wrong in my sheet set up? I'm using a date column for the start date, and I have parent rows for each year. 



Any futher help would be much appreciate. 

Best, 

Linda

 

Paul Newcome

Andree's solution should work for you. The difference is with the function itself.

 

COUNTIF only allows one set of range/criteria whereas COUNTIFS (with the "S" on the end) allows multiple sets.