counting

  1. A

    Count consecutive numbers in Array

    Good day Experts..please help me with this I have 3 Columns with single digit numbers, I need to know how many times each digit repit consecutively.ex 345 367 410 123 012 306 here we can see 0 repit 1 times (rows 5, 6), 1 = 2(rows 3, 4 and 4, 5), 3 1 times (rows 1 and 2) please help with the...
  2. O

    Counting multiple fractions, separated by commas, inside multiple cells, only if the number is larger than a certain threshold(80%)

    Hi, I am looking for a formula that can count the number of fractions 80% or larger in a range(in which cells can have multiple fractions inside, separated by commas), with the exception of 5/7, which should be counted despite being smaller than 0.8. For example, if the selected range is like...
  3. P

    counting particular hierarchical column with condition

    I would like to count the number of 1s (on the left) and organize as shown on the right. notice rows 1 and 2 are hierarchical. in other words, something along the lines of "count soccer players in 2020 in Europe" My attempt was to first match headers then count the column returned by INDEX, but...
  4. G

    Formula continues to count up

    Good day, I've got this formula below that I'm having issues with. =IF(AND($A50<>"", $A$5>34),$A50+1,"") Essentially $A$5 starts at >1 in Cell A17 and in Cell A18, I changed it to 2 - it continues like this up to $A$5>34 like you see above but I've had to do that manually because when I tried...
  5. J

    Formula for counting

    I am trying to achieve the results in D3. I'm in need of a formula that will count unique names, ignoring the blanks and duplicates. Also ignoring the word "na" and "ns"
  6. 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
  7. S

    Counting cells by colour

    Hi All, I am wondering if there is formula whereby I can count cells based on their colour?
  8. L

    Sumproduct Isnumber Search is returning same result for different values

    ​Hello - I utilizing a formula that is intended to count the number of visible entries in a table that meets multiple criteria utilizing Sumproduct, Isnumber, and Search. However; I have just realized that in some instances the formula is including results it should not. For example, in the...
  9. L

    Counting number of repeaed IDs

    Hello everyone! i need to make a report with the number of times that a user buy a product... the report must be separated into ranges, and the number of IDs varies from 1 to 20 in the table. im working on power bi; maybe i need to use a measure? i leave a img of my idea. THX nwn <3...
  10. B

    Countif

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

    Counting A Calculated Cell

    Hey Guys, I have a calculated cell in excel using and if function. e.g if(A2<50, "Poor","Good") across many rows of data. How and want to use a countif function to get the total count of the Poor and Good. But it seems like excel countif function does not count data that is returned from an IF...
  12. B

    Right to left counting cells with value until the first empty cell

    I'm looking to count from right to left counting the number of cells with a value until the first empty cell. All cells are formulas. The range is set D:Y. I need to count cells that are greater than 0 until it reaches an empty cell. Can someone help me out with this ?
  13. C

    stop counting in a cell when another has a date entered

    i am working an excel file that i need the counter to stop after i enter date in another cell G4 has date entered: 5-apr-19 H4 is the due date formula: =WORKDAY(G4,9) I4 is counter: =TODAY()-H4 J4 is date completed: 9-apr-19 what i need is I4 to stop counting when J4 date is entered
  14. A

    Stop counting day if another cell is populated

    Hi :) I need help trying to create a formula that will stop counting in B2 once I enter a date in C2 and want B2 to retain the count it stopped at. Currently B2 is =TODAY()-A2 A B C <colgroup><col><col><col></colgroup><tbody> Initial...
  15. I

    COUNTIFS not counting

    Hi I'm learning about COUNTIFS and I don't understand why this is working in one row and not another. In my first cell in question My Criteria is TECH (E4) in Ranges A2 to A20 and R(G4) is ranges B2 to B20 : I'm using =COUNTIFS($A2:$A20,$E4,$B2:$B20,G4) - and it seems to work, it counts 4...
  16. D

    Counting data in multiple columns

    I am trying to count data that is in multiple columns and am getting an error, what I need to accomplish is counting if column A has a date entered that is in July (7/xx/2019) and then count if column I and J has a reading that is greater then .5.
  17. D

    Formula not capturing information

    I have a countifs formula that is as follows =COUNTIFS($B73,"May",$C73,"N") and each of the cells has the necessary data entered to be counted but its not counting. After trial and error I have determined that its not counting because cell B73 has multiple entries May and July so I am wondering...
  18. P

    Formula Help: Counting Blanks

    Hi I am struggling with writing a formula to achieve the following: We want to count how many times there are two or more consecutive blanks. Below is a snapshot of what the data looks like. https://imgur.com/a/SP7Ojyz In addition, while we are here - We have the following formula...
  19. H

    Countifs with Count blanks with formula

    Hi All, I would like to perform a Countifs where the second criteria is about counting blank cells, including those with a formula but a blank result. Many thanks
  20. M

    Count number of characters before, after or in between a character

    Hi Excel master, I've been struggling to figure this out and so I am requesting you help to write formulas based on this particular value: For example: CMR_01_28988699_0 Questions: 1. Formula for counting the number of characters after the underscrore after R? 2. Formula for counting the...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top