Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Marked Cells
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Marked Cells
Hi Fred,
=COUNTA(A3:A7) But, in your example, why not 5 as result? -- Kind regards, Niek Otten Microsoft MVP - Excel "Fred Atkinson" wrote in message ... | 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 | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Marked Cells
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: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Marked Cells
Because only four of the five days are marked.
Regards, Fred On Fri, 8 Dec 2006 12:25:02 +0100, "Niek Otten" wrote: Hi Fred, =COUNTA(A3:A7) But, in your example, why not 5 as result? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting cells based on conditional formatting | Excel Discussion (Misc queries) | |||
counting colored cells | Excel Discussion (Misc queries) | |||
Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
Counting filled cells in excel | Excel Worksheet Functions | |||
Counting cells, similar values | Excel Worksheet Functions |