1. H

    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. M

    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. F

    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. L

    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. D

    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. S

    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. A

    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. F

    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. L

    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. D

    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. D

    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. E

    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. L


    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. L

    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. B


    I need to edit the code below so it stops counting when it hits 0. SUggestions? =COUNTIF(K5:K29,"<=30")
  16. S

    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. C

    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. N

    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. A

    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. M

    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...

Some videos you may like

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...