Countifs with find

I have 2 columns (Stage) and (Courses) Courses is a multi dropdown, stage is a single drop down.

I want to count how many people are invited to Fundamentals 1 vs how many have completed or certified in a rollup sheet. I am either getting unparsable or invalid

This is on a rollup sheet that points to the working sheet.

=COUNTIFS({Splunk Training course}, FIND("Fundamentals 1", @cell) > 0, {Splunk Training Stage}(Invited))

Thanks in advance.

Find more posts tagged with

Reports

IT & Operations

Comments

Paul Newcome

Can you explain the BOLD portion of your formula?

=COUNTIFS({Splunk Training course}, FIND("Fundamentals 1", @cell) > 0, {Splunk Training Stage}(Invited))

TdeGroh

Yes. This is tracking training, I have a column for the status (Invited, Registered, completed, etc) and another column with a multi checkbox (Fundamentals 1, Fundamentals 1, Dashboards) So I need to count how many are invited for fund 1, then invited for fund 2, then in another cell is how many are completed or certified in fund 1.

I hope that clears it up.

Thanks

Paul Newcome

That does clear things up. It also means you were very close with your formula.

Here it is with a few minor tweaks...

=COUNTIFS({Splunk Training course}, FIND("Fundamentals 1", @cell) > 0, {Splunk Training Stage}, "Invited")

We added a comma between the stage range and the stage to separate range from criteria then we replaced the parenthesis around Invited with quotes.

TdeGroh

Looks like this does the trick, thank you, formulas are probably my weak point which is maddening when I am rolling up data.

Thank you

Paul Newcome

Happy to help!

The Community is a great source of knowledge. Don't hesitate to reach out. It is certainly much less painful than beating your head against a wall for a few days (or even weeks).

Sign in to join the conversation!

Quick Links

Trending discussions

Grouped reports with multi select dropdowns
This discussion was created from comments split from: Grouped Reports with multi-select dropdowns.
Name and Email Change - Admin Center
One of our employees recently got married and changed her name. She now has a new email address. What is the best way to update this in the Admin Center? If I add the new email as an alternate email, can I make that one the primary? Will this impact any assets that are owned by her?
Automatically fill in data across sheets
I have a work plan in a sheet with a Checkbox column to denote where major decisions are required and a separate sheet working as a RAID log. Is there an equation or automation that would allow me to automatically in the RAID log based on the checkbox? Ideally I'd only want to fill in the relevant columns that are in the…