Count number of Ms between Hs in a column

		Microsoft Office Forums > Microsoft Excel > Excel
Count number of Ms between Hs in a column

05-11-2020, 12:54 AM

Marcia

Windows 7 32bit Count number of Ms between Hs in a column

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Quote:

Originally Posted by Pecoflyer

Starting in B2 (if the A range starts in A1) try =IF(A2="H",COUNTIF($A$1:$A1,"M")-SUM($B$1:$B1),"")

and pull down

The formula returned 0 in B2 instead of 2, then in B5, the result is 2 instead of 1.
It should count the Ms below the H.

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:29 AM.