-
SUMIF across three rows
Hello everyone, I'm attempting to create a formula that will add all three rows together. I've tried: =SUMIF([Amount Written off]:[AmountWritten off], [Amount of feesWaived]:[Amount of fees Waived], [Attorney fees]:[Attorney fees]) I've also tried =SUM([Amount of fees Waived]:[Amount of fees Waived],+=SUM([Amount Written…
-
Building a multi-tier automation that works over time
Hello Community! I am working with contracts that have end dates. I would like to build an automation with 2 tiers spaced over time First tier: User checks a box (say, in June) that says "Do Not Renew". This sends an email to notify the contracts group. Second tier: The contract end date is Oct 9th and it is now October…
-
I need help creating a formula that will return a specific value based on two different criteria
I'm trying to create a formula that will return a specific value based on two different criteria. What I need is to compare a clients age against a specific percent range and return a classification as the result. for example, if a client is 42 years and has a BAI of 18%, the result of the formula would be "Healthy" as…
-
I am trying to use SUM to add the values from multiple cells in that were populated by an IF formula
I am trying to use SUM to add the values from multiple cells in that were populated by an IF formula. Example of 2 IF formulas: =IF([Member 2 Registration Type]@row = "Golf & Dinner - General Public", "135") and =IF([Member 2 Registration Type]@row = "Dinner Only", "60") The IF formulas are working as they should and are…
-
MAX Formula Help
I am working on a max formula that I can't seem to figure out how to set up the criteria. Background: I have a sheet (Intake Sheet) that is gathering project health data on a weekly basis via update request. Each week after it is collected, every row gets copied to another sheet (Historical Intake) so always have a…
-
True count of Children(), not just non blanks
Doing project roll up and trying to use the formula below to roll up a complete status. =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", "Not") However, blank cells do not contribute to the COUNT(CHILDREN()), thus if there are three children and someone deletes all values in 3 cells or any non…
-
Match Learner by Location in a Training Tracker for Metric Sheet
I am missing something, but I think it is because I am not accustom to working with dates. I am creating a metric sheet for dashboard. I have a training tracker that populates a date by a learners name & demographics (row) with columns of different courses (date columns). I didn't think the formula would be difficult , but…
-
Formula countifs and is blank
I am trying to count the number of rows that contain the purpose of "appointment help" only not how many cells contain "appointment help". Trying to determine how many calls received were the result of needing help scheduling an appointment only. I currently have 311, using, =COUNTIF([Purpose 1]:[Purpose 5],…
-
Variance Column Unparseable
hi i have 2 types of Start and End date. i have Actual start date, Actual End date and Actual Duration. also, i have Planned Start Date, Planned End Date, and Variance (for Baseline). the Actual duration is the duration of the task based on the Actual start & Actual End date. what i want is to be able to calcuate a Planned…
-
Can I add multiple rows together based on criteria? (Sumif)
Hello everyone, I'm looking for help with the Sumif formula or guidance on which one I should be using. What I'm trying to do is add the "Original Amount" and "Late fees" columns together based on them being closed. I have tried =SUMIF([Open/Closed]:[Open/Closed], "Closed", [Original Amount]:[Original Amount]) + [Late…