How do I count the number of cells

[Alan]

I have several dozens columns and 52 rows containing Data.

All the columns are labled Odd or Even
In the final (right most) Column I want to count the number of times that
that coulmn has data in it
The last row belows shows what the answer should be

Total Total
Odd Even Odd Even Odd Even Odd
5 1 2 ????? ?????
1 7 6 3 ????? ?????
5 1 2 ????? ?????
1 2 9 3 1 3

PLease help

 

[Jamo via OfficeKB.com]

Good afternoon,

To just count how many columns contain data, use:

=COUNTA(RangeToCount)

For Example:

A1 5
B1
C1 10
D1
E1 15
F1 =COUNTA(A1:E1) will give you 3.

Kind regards,
James
---
jamotarpey[at]gmail[dot]com

I have several dozens columns and 52 rows containing Data.

All the columns are labled Odd or Even
In the final (right most) Column I want to count the number of times that
that coulmn has data in it
The last row belows shows what the answer should be

Total Total
Odd Even Odd Even Odd Even Odd
5 1 2 ????? ?????
1 7 6 3 ????? ?????
5 1 2 ????? ?????
1 2 9 3 1 3

PLease help

--