-
Parent child sum formula help
I need some assistance with a formula. The requirements are: if a row is a parent, then sum the values of its child rows in column A If the row is a child, "" if the row is not a parent AND is not a child, then return the value in column A for that row. I have tried numerous permutations, some of which get close, but none…
-
Formula for Sum or just return a cell value
I am writing a 'difference' formula…the sum of cell 1 minus cell 2 is the difference. Easy. HOWEVER, if the value for cell 1 = 0 I want to return just the value of cell 2 and not subtract and get a negative number. Any ideas on combining these two? I know I'm close but I think I'm not connecting my formulas for IF and SUM.
-
Help with Countif Across Multiple Columns if the Row Starts with "Project Mangement"
Hello, I am struggling with a formula and hope the community can assist me. I've created a helper sheet to automatically pull in the month, day, and day of the week. The goal is to count the total number of green or blue symbols that occur in August if that row starts with "Project Management". For example, looking at the…
-
How to show active project phases in a dashboard bar chart
Hello, We have multiple projects. We are trying to show the number of projects per active phase. Ie. 3 are in Strategy phase, 2 are in Creative Development, 4 are in Studio Production, etc… Our projects all use a template project plan sheet that has tasks (children) grouped by phases (parents), dates and predecessors. Each…
-
Can I count rows that contain an option from a multi-select dropdown?
I have two tracker sheets: one for tax accounts, one for individuals that have POA authority. I want to be able to count the number of tax accounts that each POA is assigned to ONLY for accounts that have one of the tax types that they are approved for. Is this possible?
-
What is the formula to show what quarter we are in a fiscal year
What would the formula be to show what quarter we are in a fiscal year from today's date? For example 23rd August would be Q2 or 2
-
INDEX/MATCH to enter a number based off a month name.
I'm trying to get an index match formula to enter the number of a quarter based of the month completed name between my working sheet and a helper sheet: =IFERROR(INDEX({SourceMonthName}, MATCH(MONTH[Month Complete]@row), {SourceQuarterNUmber}, 0), "") I keep getting #unparseable
-
Sumifs showing unparseable
Ok team, I have successfully added several gray hairs to my already aging head!!!! 😫 I am trying to calculate the sum in a column with multiple criteria from another sheet. However, I'm consistently getting unparseable. I need it to add some numbers in a column provided they are in 2023 AND it has the same text in the…
-
Summing data across multiple monthly columns and sheets where criteria is met.
I am trying to get a total for each location across multiple sheets. Each sheet has a location column and Aug-24 to Dec-26 (one column per month). So, location of employees with their work hours in rows in the monthly columns. I'm trying to get the total hours per location on a separate metric sheet. So start with:…
-
I need help with formulas!
Hello, I am trying to create a dashboard for our staffing office and trying to create a visualization of how many of each discipline (RN, MHW) are assigned to each shift. I have a separate Metrics sheet where I have the total for each shift and the total for each Discipline; however, I cannot figure out the formula to…
