yogi_Count Instances Of An Entity Or A Combination Of Specified Entities In A Column

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #557    May 24, 2012     www.energyefficientbuild.com.

user jmcddonal said:
Looking for Google Doc equivelent formula to COUNTIFS
Can someone help me with this? I'm not really very good with Excel and I need to create a Google spreadsheet that I would normally use a COUNTIFS statement.

Have a spreadsheet has a list of computer laptop hostnames where the first three letters of the hostname determine whether it is a PC assigned to a Faculty member, or non-Faculty admin staff, with a total for each.

Here's a sample of the spreadsheet data I am working from

e1 Hostnames:

e2 LTFAAA

e3 LTDBBB

e4 LTDCCC

e5 LTDDDD

e6 LTDEEE

e7 LTDEEE

e8 LTSFFF

e9 LTSGGG

e10 LTCHHH

Total Faculty PCs (LTF*) - This works OK: =COUNTIF(E2:E10,"LTF*")

Total Admin PCs (LTD* and LTS*) THIS IS THE ONE I CAN'T FIGURE OUT

Total Academic PCs (LTC*) - This works OK: =COUNTIF(E2:E10,"LTF*")

------------------------------------------------------------------------------------------------------------

following is a solution to the problem