CountIFS- Name + Status

I am trying to enter a formula that will count when the name Kara is listed and the status is listed. I keep either getting an error or it will double count. Please help. The end goal is to find ou how many each person has in each status listed.

Example:

=COUNTIFS([CSMNAME]:[CSM NAME], "Kara", Status:Status, "Locked")

Find more posts tagged with

Formulas

Support

Comments

Andrée Starå

Hi Ciera,

Try this. (Your columns were wrong it seems)

=COUNTIFS(CSMNAME:CSMNAME; "Kara"; Status:Status; "Locked")

The same version but with the below changes for your and others convenience.

=COUNTIFS(CSMNAME:CSMNAME, "Kara", Status:Status, "Locked")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

CieraB

It still comes back #unparseable

CieraB

also, i tried with comma also and got the same error

Andrée Starå

Try this.

=COUNTIFS(CSM:CSM; "Kara"; Carrier:Carrier; "Comcast")

The same version but with the below changes for your and others convenience.

=COUNTIFS(CSM:CSM, "Kara", Carrier:Carrier, "Comcast")

Did it work?

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.