-
SUMIF across a range
Hi All, I'm trying to use SUMIF to sum the total of all rows that meet a specific criteria * =SUMIF([SERVICE TYPE]:[SERVICE TYPE], "Monthly Charge", [2017-12]:[2018-01]) This however returns #INCORRECT ARGUMENT. Not sure what I am doing wrong. Any suggestions would be most appreciated. Regards Colin
-
How do I - formula ques
I have a formula =COUNTIF(Age8, >65) which is working, but I want it to only give me a count if a certain checkbox field is checked. Is there a formula for this?
-
SUMIFS Formula Needed for Multiple Calculations Summing from the Same Column
I am working on a budget sheet, and need to be able to calculate OPEX expenses per site, and CAPEX expenses per site. I've got 6 different sites, and need these totals for each quarter. The formula below seems to work, but I can't use it more than once within the same column without getting a circular reference error. This…
-
Turnaround time for the month of...
I have a sheet with thousands of projects. When a project is finished there is a cell that automatically calculates the turnaround time. There is also a column for the date the project was finished. The projects are not ordered by date. On another sheet I need to calculate the average turnaround time for a given month for…
-
Count Ifs Formulas
I need help figuring out why this formula is returning Invalid Data Type: =COUNTIFS([Conversion Status]:[Conversion Status], "Won", [Date Requested]:[Date Requested], MONTH(@cell) <= "3", [Year]:[Year], "2017") I want to count the number of lines that have a Conversion Status of "Won" that also took place in March of 2017
-
Form get value as tekst from som users
I got a form and the value is present as text some on some users and as number on others. Why is that ? The calculations get wrong withe the texts. Regards Jonathan
-
Counting Occurence of String of Text in a Column
Hi, I need suggestions on how to count string of text on a column. For example, i need to count how may GRC are there on the sample below: GRC Aer, GRC Aer, CDIR, GRC HTM etc. etc. Thank you!
-
SUMIFS criteria
Hi All, I'm trying to do a SUMIFS, and whilst I can return a result individually using SUMIF, when I try and combine I get #INVALID OPERATION. The formula I am trying to use is =SUMIFS({SERVICE DETAIL}, LEFT(@cell, 3) = "Col", {FEB 18}, {SERVICE TYPE}, "Transition", {FEB 18}) RESULT = #INVALID OPERATION If I separate it…
-
Countif with Checkboxes
I need help doing a countif with checkboxes. I have a formula I need to countif in column Project if it has a value of Yes and column Parent Task is check. I also need it to countif column Project also has a value of partial. This formula worked until I tried to add the Parent Task column equaling 1. Anybody know what I am…
-
If(and(countif equation question
Attempting to make a status bubble roll up where the parent will turn green if there are any blank ("") cells except for when all child cells are blank. Below are some of my failed attempts: IF(AND(COUNTIF(CHILDREN(), "") > 0, COUNTIF(CHILDREN(), "") <> COUNT(CHILDREN())), "Green") results in blank cell only when all…
