ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   count text in non consecutive cells in column (https://www.excelbanter.com/excel-discussion-misc-queries/126811-count-text-non-consecutive-cells-column.html)

Wendyfree

count text in non consecutive cells in column
 
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.)



All times are GMT +1. The time now is 07:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com