Trying to create COUNTIFS formula

Adam McCarthy

Hello.

I am trying to create a formula that will count occurrences of multiple things happening. Anytime a certain person (Name column) is found and anytime a date qualification (Date Qualification Completed column) was completed withing the last 90 days. I am using a data sheet as I want to use this output for a dashboard. Here is the formula i use: =COUNTIFS(Name column),"Carolyn",(Date Qualification Completed column),>=TODAY(-90) and it comes back #unparseeable or #invalid ref. Any ideas

Carson Penticuff

Is the formula in the same sheet as the data? If so, I believe this should work.

=COUNTIFS([Name column]:[Name column],"Carolyn", [Date Qualification Completed column]:[Date Qualification Completed column], >= TODAY(-90))

Nick Korna

Hi @Adam McCarthy,

Your formula should look something like this:

=COUNTIFS(Name:Name, "Carolyn", [Date Qualification Completed]:[Date Qualification Completed],

Make sure that the Date Qualification Completed column's type is set to Date, as it won't work properly if it's set as Text/Number.

Hope this helps - if you're still having issues then just post! 😊