Countif
Discussion List
- I am trying to do a sheet summary formula to get the percent of tasked closed assuming Project Name is "RPA Project" Please see formula: =IF([Project Name]:[Project Name] = "RPA Project", (Closed# / […
- I am attempting to create a chart on my dashboard that shows how many reports an individual has completed within the year. I created a new sheet, and use the =countif formula within the cell but keep …
- I'm trying to do a countif formula between a specific range of years, while referencing from an alternate sheet. This is the sheet with all my data (of course, just a small example) And this is the ra…
- I have a COUNTIF but it is retruning a value that represents the entire sheet and not just the number of cells on the filtered sheet. Is it possible to restrict the formula to the filtered sheet only?
- I am getting a #INCORRECTARGUMENT on this, what did I do wrong? =COUNTIFS({Range 4}, "xxx", {Range 7}, "xxx")
- Hi all, I have three columns. One column has a program name (identifier) One column has an identification number (100020000) One column has a time span (spring, summer, fall, winter) I only want to co…
- Hello, I have tried to calculate our NPS score, but am getting either UNPARSEABLE or 0. What am I doing wrong here? I've tried this formula (NPS Score 1): And this one (NPS Score 2):
- The issue I am trying to resolve is that when the sheet has 500 rows i want automation to move a number of them elsewhere. lets say i want to move everything numbered from 350- 500. so i need each row…
- Greetings, I'm trying to figure out if there is a way to count a person if they show up in two different sheets with two different selection options. For example, user Amanda Perry could be on sheet 1…
- I am trying to count the number of submissions that came from the US in the first quarter, but the formula keeps failing. Any ideas? =COUNTIF(({2024 Range 4}, "United States") + COUNTIF({2024 Range 4}…