Avatar of rtod2
rtod2Flag for United States of America asked on

COUNTIF

I need the COUNTIF function to show appropriate values in B15, B16, and B17 as shown at the bottom here http://screencast.com/t/HmH4TAZTqE .  My sheet is attached.  Assistance is greatly appreciated.
EE6.xlsx
Microsoft Excel

Avatar of undefined
Last Comment
rtod2

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
jimyX

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
rtod2

*School*  

NOT *Church or School*
ASKER
rtod2

Thank you jimyX,
All I need now is NOT *Church* OR *School* somehow?

Also, I have an additional request if you can swing it.  How can I put the totals for each in the three (3) C cells next to it?
jimyX

But how to tell if it's a Clinic or School?
If you were looking for exact two words (Church & School) and one is always mentioned, and it's guaranteed that the list of items are just those two, then that would be easy, which after finding the count of the first criteria (Church), we subtract that count from the total number of items in the list to know the other. Theoretically this sounds OK but still not reliable method to apply.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER
rtod2

Hi,
Thanks for continuing with this...

For Churches I have your suggestion:  =COUNTIF(A2:A12,"*Church*")
For Schools I have your suggestion:  =COUNTIF(A2:A12,"*School*")
For neither school or church, I have:  ??
For totals in the next column:  ??
SOLUTION
jimyX

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
rtod2

AWESOME!

For the totals, I was talking about something like this http://screencast.com/t/AOkWei2P
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
rtod2

Outstanding, Thank You!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.