Tuesday, January 2, 2018

yogi_Count Number Of Entities Based On Specified Criteria From Data In Other Sheets

Google Spreadsheet   Post  #2339

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-02-2018

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.

https://docs.google.com/spreadsheets/d/1dl6P3lB4DG0EOdepff887dEbjmGUeUukJtEBFWxxlvY/edit?usp=sharing

Thank you ahead of time!