filter and formula combination

[playerten]

I am very curious whether or not what I am seeking can be attained. I am trying to create a formula enabling a formula in a cell to recognize my Auto Filter selection. Since the selection is always a specific cell, I can only get the formula to search in one cell...Is there a way to do this?

 

[IML]

On 2002-09-03 10:42, playerten wrote:
I am very curious whether or not what I am seeking can be attained. I am trying to create a formula enabling a formula in a cell to recognize my Auto Filter selection. Since the selection is always a specific cell, I can only get the formula to search in one cell...Is there a way to do this?

You create an array type formula to grab this one number, but it may just be easier to use subtotal. For example
=SUBTOTAL(9,$B$2:$B$20)
if your list occuipies B1:B20 with a header. This will only add the one visable cell that remains.