-
Count if "Compliant" and if Blank
I am looking for the correct formula to count if cells in a range are "compliant" and if they are blank. I have tried several ways with no success, including: =COUNTIFS([Bandera Q1]114:[Bandera Q1]131, "Compliant" + COUNTIFS([Bandera Q1]114:[Bandera Q1]131, "")) =COUNTIFS([Bandera Q1]114:[Bandera Q1]131, "Compliant",…
-
How to find the Top 5
I am trying to find the top 5 majors. I created a "helper" column as some have suggested in other posts. This column gave a number for how many people are in school for that major. Now I just need a formula to find the top majors.
-
Rollup Sheet vs Report Counts Don't Match
Hi there, I have a rollup sheet with a formula to count names based on specific criteria. I need to count items that are not decommissioned, development, stating, test, Linux, numbers 7, 2003, 2008. Unfortunately, the formula does not work. To validate, I created a report filtering the same parameters. The counts between…
-
Automation - Dates!
I have a spreadsheet that I want to update the following cells: Order Date (this is the date an order is placed) Start Date (this is the start date of a range for purposes of requesting documents) End Date (this is the end date of a range) How can I set up an automation so these dates will automatically update every…
-
How to flag the second largest date in a sheet
I have a sheet that collects responses from a form, specifically collecting status. I pull this data in to a second sheet to be able to show current and previous status on the same line. To do this, I am creating a helper column to flag the second largest date. I know how to find the most recent entry (largest date) using…
-
How to count Child Items based a dropdown list of criteria
I want to be able to summarize how many child rows are open in the Purchasing Status column. This is a dropdown list column. In this example I want to count what is Not Ordered and Ordered. Ideally I would like to do that in the Parent row for Detail "000", but as a dropdown column I suspect I'll need to enter the formula…
-
Index Match Between Sheets Working Sporadically
Hello, I am trying to make a currency conversion chart where if a user in Sheet 1, can choose a dropdown in [Column9] and it will index match term with Sheet 2, matching [Primary Column] and returning [Column2] back to Sheet 1 in [Column8]. Sheet 1 Sheet 2 The issue I am having is that the Index Match will sometimes not…
-
How to fix this issue i am getting with Sum and trying to add a qty based on a budget number
I want to sum a number of quantities based on a criteria that checks the budget number to the row in the purchase request sheet that has the same budget number to then add all those quantities up in a cell in the budget so this way Each budget line that is used in a purchase request the qty of how many items purchased is…
-
Not working
there is a column that is supposed to say "Yes" when all 23 columns have either satisfactory, unsatisfacctory or N/A filled in. right now it is saying "No" for all of them and i believe it is beacuse the N/A is throwing off the formula. what should the formula be?
-
Dynamic Reporting for Newly added projects
Hello I am looking for functionality / configuration that will reduce the administrative effort to our portfolio reporting when a new project is added. Today I have to go into every report and manually add the sheets from the project folder to the report in order to keep the portfolio data accurate. My current structure:…
