Thursday, May 24, 2012

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