# countif

1. ### Nested If, countif, sumif, etc

Long story short having problems figuring out how to do this. Does this look wrong or not possible? =if(Log!D2:D1000=B2,countif(Log!Z2:Z1000,"Over"),+0) In words If a cell on sheet Log in the range D2-D1000 is the same as cell B2 on the current page, count the cells in column Z on the Log...
2. ### Find / Search Duplicate Values in slash or (-) character Data in one cell

I want to find a value among the multiple values in one cell, I hope the given picture will help understanding the actual issue. Hope to get some solution from some Mr. Excel :) P.S :- Please i need some formula instead of VB Code
3. ### Function count if for text in textboxes VBA Excel

Hi, I am doing a userform where I have 8 textboxs named ddc, example: ddc1, ddc1...ddcn. then I have another textbox name quantcoup, that is the textbox I want to receive the count if of everyone of the ddcs that have text in it throughout a command button. Also, I want that the count if detect...
4. ### Resource Allocation calculation

Dear members, Need help in creating resource allocation report. Trying to pull data from a worksheet "Resource Mapping" worksheet (one of the 4 worksheets in the Resource allocation file) onto a "Report" worksheet where conditions are, 1) "Resource Mapping" worksheet project code = project...
5. ### 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...
6. ### 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...
7. ### 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...
8. ### 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...
9. ### 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
10. ### 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...
11. ### 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...
12. ### 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...
13. ### 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...
14. ### 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...
15. ### Countif

I need to edit the code below so it stops counting when it hits 0. SUggestions? =COUNTIF(K5:K29,"<=30")
16. ### 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...
17. ### 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...
18. ### 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...
19. ### Countif in power query

Hello How do I execute the following code in Power Query? =IF(COUNTIF(\$B\$2:B2,B2)=1,1,0)
20. ### 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...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...