Counting Marked Cells

[Fred Atkinson]

Is there a function available that would count the number of
cells that are not blank?

Example: Attendance sheet:

A3 A4 A5 A6 A7
M T W Th F
X X X X =<somefunction>(A3:A7)
<somefunction> would yield '4' in this case.

Regards,



Fred

 

[Niek Otten]

Hi Fred,

=COUNTA(A3:A7)

But, in your example, why not 5 as result?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Is there a function available that would count the number of
| cells that are not blank?
|
| Example: Attendance sheet:
|
| A3 A4 A5 A6 A7
| M T W Th F
| X X X X =<somefunction>(A3:A7)
| <somefunction> would yield '4' in this case.
|
| Regards,
|
|
|
| Fred
|

 

[Nils Morten]

Hey Pal

I suggest using =counta(offset
=count(offset(A1;2;0;3;5))

A1 is the table-reference celle
2 is number of rows beneath table-reference cell = upper left cell in
offset range area
0 is number of columns right to table-reference cell = upper left cell
in offset range area
3 is number of rows in the offset range area
5 is number of columns in the offset range area

By making the constants 2,0,3 and 5 linked cell, the formula will count
the entries in a dynamic range - I think.....

Example: Attendance sheet:


A B C D
E
1
2
3 A3 A4 A5 A6 A7
4 M T W Th F
5 X X X X





Fred Atkinson skrev:

 

[Fred Atkinson]

Because only four of the five days are marked.

Regards,



Fred