Thread: [Solved] Count number of Ms between Hs in a column
View Single Post
 
Old 05-11-2020, 12:54 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
Quote:
Originally Posted by Pecoflyer View Post
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.
Reply With Quote