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
|