View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default SUMIF formula while filtering

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