countif(s) with two criteria

**eeps24** · 06-13-2018, 09:55 AM

In cell b9 (red arrow) I want a formula that will count how many "worked" OR "working" are in that entire row. I tried doing countifs but I think its looking for cells that contain both words. I just need it to find the number of times "worked" and 'working" comes up and add that total in b9.

work.PNG

**PaulM100** · 06-13-2018, 10:07 AM

Try:

=COUNTIF($D2:$T2,"Worked")+COUNTIF($D2:$T2,"Working")

**Jonmo1** · 06-13-2018, 10:08 AM

Try

=COUNTIF(C9:K9,"Work*")

**eeps24** · 06-13-2018, 10:11 AM

Thanks Jonmo1, that worked! keeping it easy I like it.

Thanks Paul, I didnt try your method but I am sure it would work.

**Jonmo1** · 06-13-2018, 10:14 AM

You're welcome.

countif(s) with two criteria

LinkBack

Thread Tools

Rate This Thread

Display

countif(s) with two criteria

Re: countif(s) with two criteria

Re: countif(s) with two criteria

Re: countif(s) with two criteria

Re: countif(s) with two criteria

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] The Countif Criteria

Return dates that match a single criteria (a countif criteria)

CountIf with two criteria

COUNTIF with two criteria?

Countif w/ Multiple Criteria-How do I use countif

Countif using format criteria not number criteria?

[SOLVED] Countif using format criteria....not number criteria?

Bookmarks

Bookmarks

Posting Permissions