Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count is not working
Okay, this is BASIC and I feel bad for asking, but I can not get my
count to work. I have a spreadsheet with a list of doctors names and other information, I tried to do a count on the column using the following formula: =count(D:D) And Excel gave me 0. I tried this on other columns, it worked, there is no formula in the column, my spreadsheet is not on manual calculate, when using the little ghost function in Excel I am able to get a count for the row in question, but the formula won't work. I found a work around by counting another column, any ideas on why it is not working? Richard |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count is not working
Count counts numbers
you said list of names try counta Steve On Wed, 16 Aug 2006 13:24:43 +0100, wrote: Okay, this is BASIC and I feel bad for asking, but I can not get my count to work. I have a spreadsheet with a list of doctors names and other information, I tried to do a count on the column using the following formula: =count(D:D) And Excel gave me 0. I tried this on other columns, it worked, there is no formula in the column, my spreadsheet is not on manual calculate, when using the little ghost function in Excel I am able to get a count for the row in question, but the formula won't work. I found a work around by counting another column, any ideas on why it is not working? Richard -- Steve (3) |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count is not working
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Count is not working
Might also want to consider looking at Data / Subtotals for that kind of info.
-- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------- It's easier to beg forgiveness than ask permission :-) " wrote: Okay, this is BASIC and I feel bad for asking, but I can not get my count to work. I have a spreadsheet with a list of doctors names and other information, I tried to do a count on the column using the following formula: =count(D:D) And Excel gave me 0. I tried this on other columns, it worked, there is no formula in the column, my spreadsheet is not on manual calculate, when using the little ghost function in Excel I am able to get a count for the row in question, but the formula won't work. I found a work around by counting another column, any ideas on why it is not working? Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
retirning count values from calcualted fields | Excel Discussion (Misc queries) | |||
How do I count wildcard text meeting certain criteria in EXCEL? | Excel Worksheet Functions | |||
Count Help | Excel Discussion (Misc queries) | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Working days left in the month compared to previous months | Excel Worksheet Functions |