Countif
Discussion List
- Is there a way to use COUNTIFS and CONTAINS to count cells that include a specific string of numbers as well as cells that include that string plus something else? In the example below, I'm trying to …
Countifs where sheet range is formula returning a number and criterion is sheet summary dynamic drop
I have a column called '"Wave" which shows a number 1-10. The value is returned on some rows from a =PARENT formula and on some rows it's hardcoded. (I understand it should be either formula or hardco…- Hello, I have been out of the game for a bit and having trouble writing this formula. Trying to collect monthly data for completed calls. Currently I have my formula written as this: =COUNTIFS({Status…
- I have a sheet that list PC that has been deployed to a user at a given location The detail sheet has the suer location and a checkbox for when the PC has been deployed. On a summary sheet, I am track…
- Hello all!! So currently trying to get a sheet summary formula to show the number of Dealer ID's that are not enrolled. Pretty much just need the number of Dealer ID's shown on the SS when the Enrolle…
- I am setting up as simple tracking of an annual communications plan and have a Platform of Engagement column with about 12 drop down platforms to select from. I want a formula to track the amount of e…
- Hello, I have a set of form responses where 350 colleagues have given their job level, and provided their 5 personal goals (in separate columns), and which of our organisational targets their goal ali…
- Happy 2024 everyone, I hope your year is off to a great start! I'm back requesting help to get some formulas working. I am trying to use the countif formula to count a column in a sheet. I am trying t…
- Hi, I am trying to collate the number of project assigned to individuals by using the COUNTIF function: =COUNTIF({Project Dashboard Range 1}, "Colin Alexander") The problem is, that it is picking up a…
- What am I doing wrong? I can't get this COUNTIFS formula to work!!! I have tired so many iterations. A note that the "Opportunity For" and "Cycle" are referencing a column in a sheet. This works: =COU…
