How do I count the number of cells
He Shoots he scores
Thanks Rick
Excellent help
"Rick Rothstein" wrote:
Maybe this?
Odds: =SUMPRODUCT((A$1:H$1="Odd")*(A2:H2<""))
Evens: =SUMPRODUCT((A$1:H$1="Even")*(A2:H2<""))
Change the A thru H example columns to the actual column limits you are
using.
--
Rick (MVP - Excel)
"Alan" wrote in message
...
but that will also count the even columns
I need to count the number of columns that only have "even" on the top and
data in them
and count the rows seperately that say "odd"
"trip_to_tokyo" wrote:
=COUNTA()
- will count the number of non blank cells.
In the brackets place the range name (for example A1:A2).
Please hit Yes if my comments have helped.
Thanks.
"Alan" wrote:
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
.
|