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.
Tuesday, January 2, 2018
yogi_Count Number Of Entities Based On Specified Criteria From Data In Other Sheets
Problems with COUNTIF creating data collection sheet
Hello. I manage a business where clients rent different "Tier" locker(s) based on their needs and am trying to start collecting data based on other sheets from a workbook.
The "Clients" tab is normally a complete list of every client, contact info, and other data.
The "Lockers" tab is a list of every locker that auto-fills based on data from the Clients tab. This is used to populate the data tab. The "Data" tab is new, but the first thing I want it to collect is general capacity information.
I need help with the Data tab. I have all the basic formulas in, but need a function that can fill in the "leased" column. This would be a count of every cell in column C (Lockers Tab Last Name) that isn't yellow or red (doesn't end with a "*"), but based on the corresponding Tier in column D (i.e. "1st)
I was told using an asterisk may be a problem because it is used as a wildcard. If so, please let me know what I would need to change to make something work.