-
COUNTIF using 2 criteria
Hi, I'm trying to count the number of accounts using Experiencia with following criteria: Rounding Status is Operational AND EHR Status is NOT Operational. I'm getting an unparseable error with this formula: =COUNTIF([Experiencia Rounding Status]@row = "Operational", [EHR Integration Status]@row <> "Operational") Next, I…
-
Reports - calculating the gross margin rate
I am using Reports to bring data from multiple sheets in a project, but i need to calculate the project GMR (gross margin rate), how can I do this??
-
Countifs with blank "0" Value
Hi I am trying to put a formula together that will return blank if the value is zero based on 2 criterion.. example =COUNTIFS({Range 4}, ="Food & Beverage", {Range 3}, ="Unqualified" > 0 "") So basically if the value of unqualified is zero, I want the cell to be blank.. any tips?
-
#INCORRECT ARGUMENT error
Hi (again!) From other answers I've found here I'm guessing this is a parenthesis issue but I can't work out which ones. =COUNTIF({Clinical Trials : Accepted Range 1}, >=TODAY(), {Clinical Trials : Accepted Range 2}, HAS(@cell, "Blacktown")) Trying to sort current contracts (expiry date today or later) by research site ie:…
-
Pulling data dynamically from standard project folders
We found a template for multiple projects that uses a standard folder setup to keep Reports, Project Plan and Dashboards for each project within its own project folder... allowing us to have the separate lists of tasks and RFI's, rollups organized for each project rather than a forever-growing list of entries from old…
-
Formula to exclude expired dates
I'd like to count how many "current" contracts we have My reference sheet has a column for estimated end date, I just can't find the right formula to exclude dates that fall prior to todays date Thanks!
-
Formula to exclude expired years
Hi Hi, I'd like to count how many "current" contracts we have and also how many we have up coming close to expiry (say in the next 60 days) My reference sheet has a column for estimated end date, I just can't find the right formula to exclude dates that fall prior to the current date. And I have no idea how to write the…
-
How to add columns based on user input from another column?
I have a field called Number of Children in my form. The user then inputs the number of children they have. What I am looking to do is have other fields added based on what the user input for the Number of Children field. For example, if the user inputs 4 in the Number of Children field, I want a Name, Age, and Gender…
-
INVALID DATA TYPE error
Hi, I'm trying to count the cells that match these criteria but am getting an invalid data type error. =COUNTIFS(OR({Tier}, "Experiencia", {Tier}, "Experiencia Plus", {Tier}, "Experiencia Plus Unlimited"), {Renewal Month}, 1, {Renewal Year}, 2023) The formula worked successfully without the OR statement: =COUNTIFS({Tier},…
-
Countifs from one sheet with multiple categories
I need to complete a countifs formula for data in one sheet with multiple categories (screenshots of data needed). The columns that need to be counted have different drop-down options. I have to count active status defects the total (New, open, Assigned, Ready for Retest, Assigned to Vendor, Reopened) for each module. The…