Google Spreadsheet Post #2339
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Jan-02-2018
question by: Ryne Vories
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.
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/
Thank you ahead of time!
No comments:
Post a Comment