Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count if on Visible - Filtered | Excel Worksheet Functions | |||
Count Filtered Visible Items that Match Numeric Criteria between two ranges | Excel Worksheet Functions | |||
sum only visible cells | Excel Worksheet Functions | |||
count only visible cells | Excel Worksheet Functions | |||
Autofilter - display column showing visible row count | Excel Discussion (Misc queries) |