-
Help with #Divide By Zero
How do I adjust the syntax in this formula to avoid the '#Divide By Zero' error? I would like it to return a black cell for the months where this no data yet. I've tried using IFERROR in a variety of ways but that's either not the right solution or I'm not applying it correctly. =AVG(COLLECT({Order Submission Time},…
-
Using COUNTIFS when two different ranges
I need a count of items with program = "VRN - Website" but do not count the ones with status = DONE OR NEW =COUNTIFS({Programs}, "VRN - Website", NOT [{Status}, "Done" OR "New"]) What am I doing incorrect?
-
Formula to enter a date based on the value and activity date of another column
Hi all, If Column A has a check mark, is it possible to enter a date in Column B to show the date column A was checked? Thanks
-
when I use the SUMIF formula to return data from a sheet, it returns 0, WHY?
When using the SUMIF formula, it should return specific data that I outline. However it returns 0. The sheet that contains the data does not display 0. my formula is not returning the correct data as if there is a miscommunication between the two sheets. Has anyone ever ran into this? Below if my formula.…
-
#CIRCULAR REFERENCE with =SUMIF Formula
For each month, I am trying to sum up data depending on the type of project it is. For example, "If the 'Project Type' is 'Strategic', this is the total hours for the month of February," "If the 'Project Type' is 'Operational', this is the total house for the month of February." These the formulas I tried using:…
-
SUMIF(CONTAINS...
I'm trying to gather info from another sheet but keep getting the "Unparseable" error message. Basically, I want to add the total amounts of any rows that contain "1st" as the district. The column that has the district information is a multi-select value hence why the contains. The current formula is set as: =SUMIF(…
-
Can I use a cell value in the sheet as a filter for a report that I'm using to populate a dashboard?
Scenario: I have a dashboard that updates every two weeks (sprints) that uses several reports to show work completed, in progress, and blocked (all three different reports). Each of those reports represents data from the master backlog file, based upon the current sprint as a filter for those reports. Complication: The…
-
Incorporating OR within COUNTIFS with Checkboxes
In English, this is what I am looking for: Total number of tasks with any of these names (Manager, IC, Lead, Director, Grand Poobah) that have the checkbox checked =COUNTIFS([Task Name]:[Task Name], "Manager", Done1:Done53, 1 (OR([Task Name]:[Task Name] = "IC", Done1:Done53, 1, [Task Name]:[Task Name] = "Lead",…
-
EOMONTH Formula
Hey everyone, I am trying to add a formula to my pay run sheet. I have tried =IFERROR(DATE(YEAR([Invoice Date]@row), MONTH([Invoice Date]@row) + 1, 1), DATE(YEAR([Invoice Date]@row, 12, 31))) + 30 which works, however, I need the month-end date and not +30 days as not every month has 30 days. I need my payment date to read…
-
Counting Formulas
Hello, I am looking to see if there is a formula that will collect the number of people who are coming to an event. I have a column that asks if they are attending a certain event. I know that I can collect the number of "Yes" by using the Formula =COUNTIF([SPS Reception?]:[SPS Reception?], CONTAINS("Yes, @cell)). What I…