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.

Count only visible cells
 

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.

Count only visible cells
 

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.

Count only visible cells
 

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.

Count only visible cells
 

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.