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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 09:43 AM.