LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
text filtering formula??? Garth Excel Discussion (Misc queries) 3 August 14th 07 03:39 PM
Filtering Data With Formula SteveC Excel Worksheet Functions 2 February 13th 06 08:39 PM
Filtering on a formula Timmy Mac1 Excel Discussion (Misc queries) 1 November 9th 05 07:24 PM
Filtering dates using a formula Sue Excel Worksheet Functions 5 July 26th 05 11:02 PM
trouble filtering a list. Why isn't column filtering? Pat Excel Worksheet Functions 1 July 18th 05 03:30 PM


All times are GMT +1. The time now is 05:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"