count the cells which start with text string "Splice at node:"

[awagdarikar]

Hi,

I need to Count no. of cells having common text string at start and then varying later. The data is like this in a single column and may run into hundreds of rows,

Splice at node: 13637605_X86 Part Number: 7209-5299-0W
Left Hand Side C.S.A. = 4.850000 Total C.S.A. = 4.850000 C.S.A. = 0.000000 Right Hand Side
Page: 2
Splice at node: 13653204_X16 Part Number: BLUNT_CUT_ASSY
Splice at node: 13746734_X16 Part Number: BLUNT_CUT_ASSY
Page: 3
Splice at node: 19153416_A96 Part Number: BLUNT_CUT_ASSY
Splice at node: 1_13235988_A Part Number: BLUNT_CUT_ASSY
Page: 4
Splice at node: 1_13637605_X Part Number: 7209-5299-0W
Left Hand Side C.S.A. = 3.500000 Total C.S.A. = 3.500000 C.S.A. = 0.000000 Right Hand Side
Splice at node: 1_19153416_A Part Number: BLUNT_CUT_ASSY
Page: 5
Splice at node: 2_13637605_X Part Number: 7209-5299-0W
Left Hand Side C.S.A. = 5.000000 Total C.S.A. = 5.000000 C.S.A. = 0.000000 Right Hand Side

Splice at node: 13637605_X86 Part Number: 7209-5299-0W


I need a formula is to count the cells which start with text string "Splice at node:",

Thanks in advance,

awagdarikar

 

[Jonmo1]

Try

=COUNTIF(A1:A100,"Splice at node:*")

Hope that helps.

 

[VoG]

Try

=COUNTIF(A1:A20,"Splice at node:*")

 

[awagdarikar]

THanks VoG

It works,
Regards,
awagdarikar