1. 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"
  2. 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
  3. S

    Counting cells by colour

    Hi All, I am wondering if there is formula whereby I can count cells based on their colour?
  4. 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...
  5. 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...
  6. B


    I need to edit the code below so it stops counting when it hits 0. SUggestions? =COUNTIF(K5:K29,"<=30")
  7. 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...
  8. 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 ?
  9. 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
  10. 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...
  11. 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...
  12. 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.
  13. 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...
  14. 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. In addition, while we are here - We have the following formula...
  15. 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
  16. 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...
  17. O

    Miscounting in column T

    Hi. In the linked spreadsheet, please could someone fix the count in column 'T'. It keeps counting one too many. Thanks in advance.!AtIvkRgReIvwgRbfii9zm52ozImr
  18. A

    Counting cells

    Hello, In one column (B), users can choose between 'Essential' and 'Desirable'. In another column (C), users can choose between 1 and 5. Do you have a formula for counting the numbers of Essentials in column B and the number of 1s in column C, etc.? It's one formula I need, for doing both...
  19. P

    Date counting stop

    Sir/madam I have one doubt regarding date count stop when then change status complete
  20. muhammad susanto

    Counting Data "Sold" Ignore Duplicate Number

    hi all.. how to counting data only "sold" but ignore repeate or duplicate "number document " like this : <style type="text/css"> table.tableizer-table { font-size: 12px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table...

Watch MrExcel Video

This Week's Hot Topics

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