J
Joe M.
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.
=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.