View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try something like
=COUNTIF(A2:A20,A1)

--
Regards
Frank Kabel
Frankfurt, Germany

"gats13" schrieb im Newsbeitrag
...
I'm trying to figure out a formula that will count each cell in a

range of
merged cells as having the same text as the 1st cell in the range.