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.

Hi Joe M.

You could try counta(yourrange)-countblank(yourrange)

hth

BigPig

"Joe M." wrote:

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.

Sorry, your formula also counts the cells hidden by the auto-filter. I need
to count only the visible cells. Thanks anyway.
Joe M.

"BigPig" wrote:

Hi Joe M.

You could try counta(yourrange)-countblank(yourrange)

hth

BigPig

"Joe M." wrote:

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.

Hi Joe M.

Sorry it didn't work. What criteria are you using to hide those certain
cells? Reason I ask is you might be able to you an if statement.

"Joe M." wrote:

Sorry, your formula also counts the cells hidden by the auto-filter. I need
to count only the visible cells. Thanks anyway.
Joe M.

"BigPig" wrote:

Hi Joe M.

You could try counta(yourrange)-countblank(yourrange)

hth

BigPig

"Joe M." wrote:

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.

I am using the autofilter on another column to hide some of the rows.

"BigPig" wrote:

Hi Joe M.

Sorry it didn't work. What criteria are you using to hide those certain
cells? Reason I ask is you might be able to you an if statement.

"Joe M." wrote:

Sorry, your formula also counts the cells hidden by the auto-filter. I need
to count only the visible cells. Thanks anyway.
Joe M.

"BigPig" wrote:

Hi Joe M.

You could try counta(yourrange)-countblank(yourrange)

hth

BigPig

"Joe M." wrote:

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.