COUNTIF tally meeting criteria from two dropdown columns

Hoping for some help with some formulas tally information in some of my spreadsheets.

I'm tallying data totals that meet criteria in 2 separate dropdown columns in order to turn these into charts. I need to know how many audition types (commercial, radio, etc) came from different agents or databases. Example: How many Commercial auditions came from Ecocast.

One column is labeled as COMPANY, the other as TYPE. Both columns have dropdowns with the information.

Here's my current formula:

=COUNTIF({Copy of Audition Tracker - 2025 Range 2}, "EcoCast", {Copy of Audition Tracker - 2025 Range 1}, "Commercial)")

I know it's wrong, but don't know how to correct it. Any help is really appreciated!

Find more posts tagged with

Accepted answers

Paul Newcome

You need a COUNTIFS with the "S" on the end to be able to use multiple range/criteria sets.

All comments

Paul Newcome

You need a COUNTIFS with the "S" on the end to be able to use multiple range/criteria sets.

B Guntharp

🤦‍♀️ Thank you!!!!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.