=COUNTIF - Columns "A" & "B" Has "1" & "2" Values

A. Rose

Hi,

How Can I count how many of the column "User" is "Jack" and the Column "Daily Email" is "Done"?

I want to make 1 calculation for both, how many users have these values.

I treid doing the following: (It didn't work..)

=COUNTIF(User:User, "Jack" + [Daily Email]:[Daily Email] "Done")

Thank you!

Find more posts tagged with

Accepted answers

A. Rose

The below worked.

=COUNTIFS(User:User, "Jack", [Daily Email]:[Daily Email], "Done")

Thank you!

All comments

Tiffany Hanks

COUNTIF only counts based on a single criteria. The COUNTIFS function accounts for more than one set of criteria.

A. Rose

@Tiffany Hanks

Still "#UNPARSEABLE" with the below formula

=COUNTIFS(User:User, "Jack" + [Daily Email]:[Daily Email] "Done")

A. Rose

The below worked.

=COUNTIFS(User:User, "Jack", [Daily Email]:[Daily Email], "Done")

Thank you!

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.