=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!

A Rose

The below worked.

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

Thank you!

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!