|
|
#1
05-10-2020, 05:09 PM
|
||||
|
||||
Count number of Ms between Hs in a column
Hi. Column A is populated with "H" and "M". I would like the below formula in B2 to count the number of Ms between Hs but it returns all the Ms in column A instead of the total count of Ms between Hs.
=IF(A2="H",COUNTIF(A$2:A$100,"M"),"") Col A |Col B H | 3 M M H | 3 M H | 3 B2 should be 2, B5 should be 1, B7 should be 0. What do I add to the formula that would return the correct value? Thank you. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 count a number of cells based on the beginning of a order number
|
Kubi | Excel | 2 | 08-06-2017 08:54 PM |
| Count only numbers in filtered column | Jelmer | Excel | 6 | 05-16-2017 05:24 AM |
|
Count # of times "text" is in 1 column is specific date is in the other column
|
ann.acornacchio | Excel | 4 | 12-31-2016 05:40 PM |
| Want a quotient using a constant to show up in column c each time a number is added to column b | fibbermcghee | Excel | 2 | 12-09-2014 05:48 PM |
|
count w and write into another column in excel
|
tomlam | Excel | 5 | 10-07-2012 06:09 AM |
Windows 7 32bit 
Office 2013
Threaded Mode