Countifs Function Not working

Elizabeth Creager

So, I've been working on this for a day. I have a headache lol. Can someone take a look at this formula and make suggestion as to what I'm missing?

=COUNTIFS({Staff}, "Name", ({Event Type}, "Sale")

I'm using 2 columns of data and want to do a count using Name and type of sale condition. Suggestion?

Find more posts tagged with

Accepted answers

All comments

Hi Elizabeth,

It looks like you might just have an extra parenthesis in there... try this:

=COUNTIFS({Staff}, "Name", {Event Type}, "Sale")

If this doesn't work, it would be helpful to see a screen capture of the sheet you're referencing (but please block out any sensitive data).

Thanks!

Genevieve

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.