With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Thursday, May 24, 2012
yogi_Count Instances Of An Entity Or A Combination Of Specified Entities In A Column
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
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*")