Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
wrote in message
... On May 8, 6:40 pm, "T. Valko" wrote: I think there is something else going on.... i don't think excel is counting all the numbers in column v. I did get it to work but it's not adding up to the right number Are you sure column V contains all numeric numbers? If there are no empty cells in the range and every cell contains a numeric number then this formula shoud return 254: =COUNT(V14:V267) -- Biff Microsoft Excel MVP i got it, for some reason excel wasn't recognizing column v as having numbers. I had to go through & each line & click inside the cell then click enter before the formlua would work.... thank you for your help! Glad you got it straightened out. Thanks for the feedback! -- Biff Microsoft Excel MVP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
text filtering formula??? | Excel Discussion (Misc queries) | |||
Filtering Data With Formula | Excel Worksheet Functions | |||
Filtering on a formula | Excel Discussion (Misc queries) | |||
Filtering dates using a formula | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |