# countif

1. ### Countif formula not working if used the same range as the data it is searching for

Hi, This is my formula: =COUNTIF(range,"=*Y*"); also tried =COUNTIF(range,"*Y*"); and =COUNTIF(range,"Y"). Goal: trying to count the number of "Y"s within the cell range Problem: Formula works only if I enter it outside of the range within the formula i.e if I want to find all Ys within the...
2. ### Countif returning incorrect value

Hi, I have a sheet where I have combinations of numbers and want to count occurences of these sets. The numbers are in Number Dash Number format eg 1-7 However I just did some checking and the countifs are returning incorrect values. All of the sets are in text format as otherwise it converts...
3. ### COUNTIF, MATCH, and OFFSET in Array

Hi all, I hoping for some advice here. I am trying to calculate the success rate of members of staff. I have each student's score in a number of subjects (A2:J6) and there teacher for each subject (L:U) I want to COUNT the total number of student scores over a certain amount (e.g. >5) for the...
4. ### Countif with filters

Hey guys, I've been trying to use a countif expression that allows me to check for misplaced data, which is pretty easy, however it becomes a lot more tricky when i try to make that same data respond to filters. This is the expression i have used so far COUNTIFS('A...
5. ### CountIf True

=COUNTIF(Data[Column1],TRUE) I have the above mention formula but i want to modify it to add that if Counts of Assets in BU is blank dont count the true now is counting 1,221 but it should be 1177
6. ### How to count SPECIFIC text characters with a range of cells

Hey guys, Can someone assist me in writing a formula for counting how many "I" are in a range of cells. For example I have a range of cells B11:AF12 that have different letters in it to identify the kind of Lead Source we receive. "I" represents Internet. I need to find out how many I's are in...
7. ### Combining SUMPRODUCT & COUNTIF with multiple criteria in sigle column

I have a table which has a column containing job status (e.g. live, dead, invoiced etc) and a separate column with a job fee and a third column with a Sub Fee. I have used:- =SUMPRODUCT(SUMIF(TabJobs[Current Job...
8. ### Countif with Index on a Pivot Table

Pulling off Pivot Table example: <colgroup><col><col span="2"></colgroup><tbody> </tbody> <tbody> Part Number Company 1 Company2 part 1 60 61 part 2 50 52 part 3 40 60 </tbody> Looking to do a countif on the entire row based on the part number with greater than or equal to 50. So...
9. ### COUNTIF / SUMPRODUCT with WEEKNUM

Hello Guys. A quick and simple question (too difficult for me though). I have a column with dates (Column A). I need to count the number of records that are from the certain year (YEAR formula) and certain week (WEENNUM) without using any additional calculation columns (file is big, a lot of...
10. ### COUNTA (with countif) with OR condition

Hello, You may remember me from before, I was helped to full through three different attendance types. It works lovely and I'm still trying to understand it... haha... I've come into another road bump. I had somehow figured out how to do countif with counta (I did it in a trance and was...
11. ### Countif

I need to edit the code below so it stops counting when it hits 0. SUggestions? =COUNTIF(K5:K29,"<=30")
12. ### COUNTIF in array formula isn't allowed, while COUNT is. Why ?

Can you please help me find a way around Can't figure out why this one working: {=COUNT(ISNUMBER(SEARCH(List,E522))*(ROW(List)-1))} Which evaluates in something like COUNT({2,4,6,2}). And it results in 4 Now I want to count only 2. So I use...
13. ### Countif percentage of cell containing text or if statement to produce value in specific cells

Hi there! I am trying to calculate the average of cells based on text criteria. I have to use the same column for the data I'm pulling, however, for each value I need, it requires a different set of cells within that column and I cannot get the formula to work if I don't use the whole range...
14. ### COUNTIF for a word within a phrase

I'm trying to count the number of times a word appears within a phrase. Each row lists an action taken by an agent (i.e. Policy: Transfer / Sellers). I'm trying to use COUNTIF to count how many of the row contain a specific word, like "Transfer" but it keeps giving the result as zero. I...
15. ### Countif in power query

Hello How do I execute the following code in Power Query? =IF(COUNTIF(\$B\$2:B2,B2)=1,1,0)
16. ### Count If

sheet 1 Column M has if statement that shows days outstanding, =IF([@Status]="",TODAY()-[@[Date Back Charge Issued]],"") which works perfect, now on sheet 3 I want count how many instances in column M are between 0-60, there are 6 instances but it tells me there is 30, when I use formula...
17. ### Countif formula returning the same results for entire data range that start with a prefix of < >

Hello! I'm building a dashboard and using “COUNTIF” to simply count the number of times a complaint isowned by a particular person or process… The issue I’m having is new ownershave been added to the data and the begin with < or > for example <over font="" old<="" 5years=""></over>...
18. ### Count occurrences of text within cells - not exact match

Hi, I have a number of lists with various versions of same items but want to count key parts of text within cell. For example: Column A Back bacon Smoked bacon Rindless bacon I would use countif(A:A,"*bacon*") to return the value 3. However I want to take this a step further and have a cell...
19. ### Formula to Find matching Absolute Values in a Range of Dates?

Hi Everyone, I've been developing a project for work that will analyse bank accounts to determine the value of a project. The problem is some of our projects have inter-account transactions. In order to determine the proper worth of the project we have to find any transfers between the...
20. ### countif cell contains less than 6 characters, or contains digits

How do I count a cell if it contains less than 5 characters, or contains digits (even if mixed with letters)? After data transfer, I have a list - some are email addresses, some usernames, some random text. I want to filter these to username which are less than 6 characters (for example) so us...