Help Combining CountIFs and TODAY() function

JohnBVT

Hello,

I am having difficulty with the proper syntax in my countifs function. What I am trying to do is count the instances of a word within a specific column (this I accomplished without a hitch) and then narrow those by instances that are active as of today (there is a date range for a "live date" of the word). what I tried was =COUNTIFS(Word, "Mens", [DATE1:DATE2, "=TODAY()]) and had no luck. Thank you in advance for any help! 

Andrée Starå

Hi John,

Try something like this.

=COUNTIFS(Word:Word; "Mens"; Date:Date; TODAY())

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

=COUNTIFS(Word:Word, "Mens", Date:Date, TODAY())

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