count text in non consecutive cells in column
 

Hi

Maybe something like this:

=COUNTIF(N1,"n's")+SUM(IF((MOD(ROW(N1:N100),10)=0) *(N1:N100="n's"),1))+SUM(IF((MOD(ROW(B1:B100),10)= 5)*(B1:B100="n's"),1))+SUM(IF((MOD(ROW(G1:G100),10 )=8)*(G1:G100="n's"),1))

enter using CTRL+SHIFT+ENTER

HTH
Jean-Guy

"Wendyfree" wrote:

I have a spreadsheet with text entered in the columns. I want to count only
the information in non consecutive rows. Ex:
Row# Column#
1 N
5 B
8 G
10 N
15 B
18 C
20 I need a formula to total tne number of "N's" in this column "only" in
the rows shown and skiping the text in the other rows. (count row 1 but not
rows 3 and 4, count row 5 but not rows 6 and 7, etc.)