Link to home
Start Free TrialLog in
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
ASKER CERTIFIED SOLUTION
Avatar of jimyX
jimyX

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rtod2

ASKER

*School*  

NOT *Church or School*
Avatar of rtod2

ASKER

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?
Avatar of jimyX
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.
Avatar of rtod2

ASKER

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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rtod2

ASKER

AWESOME!

For the totals, I was talking about something like this http://screencast.com/t/AOkWei2P
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rtod2

ASKER

Outstanding, Thank You!