Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count a column with any value in it?
Thanks
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count a column with any value in it?
That's a pretty vague and ambiguous question. Rather than us trying to
divine what you mean, how about you provide a little more detail. "Felix" wrote: Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count a column with any value in it?
Can you quote with example, it will make things clear
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count a column with any value in it?
I have a list of students with email, names etc
I have the data filter function on so I can look at it like a DB, but when I filter lets say on an organization to find out how many people are in that org, I have to count manually. Is there a way to add a count items function to give me an instant count? Thanks Felix |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I count a column with any value in it?
=SUBTOTAL(3,Your_Range)
Regards, Peo Sjoblom "Felix" wrote in message oups.com... I have a list of students with email, names etc I have the data filter function on so I can look at it like a DB, but when I filter lets say on an organization to find out how many people are in that org, I have to count manually. Is there a way to add a count items function to give me an instant count? Thanks Felix |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions |