Sum of some # of consecutive cells containing the same text info

[onemurat]

Can someone pls help me with this. Its driving me crazy.... Its hard for me but could be so easy for another.

I need to take the total number of 24 or more consecutive cells containing the same text info


Ex for 3 or more consecutive cells

3.5
3.5
3.5
3.5
NoData
NoData
NoData
5.7
NoData
7.6
Samp<
Samp<
Samp<
5
8
Samp<
NoData
NoData
NoData
NoData
NoData
NoData

Answer should be 12 (# of cells containing "NoData" 6+3, and # of cells containing "Samp<" 3)

pls help

[Carim]

Hi,

Could the attached worksheet be of any help ...?

[Bryan Hessey]

Can someone pls help me with this. Its driving me crazy.... Its hard for me but could be so easy for another.

I need to take the total number of 24 or more consecutive cells containing the same text info


Ex for 3 or more consecutive cells

3.5
3.5
3.5
3.5
NoData
NoData
NoData
5.7
NoData
7.6
Samp<
Samp<
Samp<
5
8
Samp<
NoData
NoData
NoData
NoData
NoData
NoData

Answer should be 12 (# of cells containing "NoData" 6+3, and # of cells containing "Samp<" 3)

pls help

Hi,

in B2 put

=IF(AND(ISTEXT(A2),A2=A1),D1+1,0)

and in C2 put

=IF(AND(B3=0,B2>1),B2+1,"")

and formula fill that down to the end of your data, then total the C column at the end

This will include sets of 7 or 8 as well as the 3 & 6 shown in your example.

hth
---