LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 97
Default Count only visible cells

I have a column B in which the cells contain this formula:
=IF(C9=C10,"",C10)
So in some cases the result is "" and other cases it has a value greater
than "". I am using an auto-filter on another column to hide some of the
rows. I know I can use formula =SUBTOTAL(3,B9:B1000) to count only the
visible cells but I don't want to include the cells where the result of cells
in column B with formula
=IF(C9=C10,"",C10) is "". Can someone show me a formula to count the visible
cells greater than ""?

Thanks,
Joe M.
 
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
count if on Visible - Filtered tonyv Excel Worksheet Functions 4 July 7th 07 07:34 PM
Count Filtered Visible Items that Match Numeric Criteria between two ranges Sam via OfficeKB.com Excel Worksheet Functions 4 September 20th 06 06:39 PM
sum only visible cells hommer Excel Worksheet Functions 5 May 11th 06 11:39 PM
count only visible cells bnkone Excel Worksheet Functions 2 March 31st 06 01:39 AM
Autofilter - display column showing visible row count rgarber50 Excel Discussion (Misc queries) 5 July 26th 05 02:17 PM


All times are GMT +1. The time now is 03:12 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"