Filtered table using Countif
 

I have an excel spread sheet table that I filter. I would like to be able to
countif the number of cells in the filtered data to the vigen contidion.
Anyone know how to do this?
Countif returns the number of cells in the unfiltered data, even when they
are filtered.
Elba
--
Not much remain to be said.

Filtered table using Countif
 

Look in the help index for SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Elba" wrote in message
...
I have an excel spread sheet table that I filter. I would like to be able
to
countif the number of cells in the filtered data to the vigen contidion.
Anyone know how to do this?
Countif returns the number of cells in the unfiltered data, even when they
are filtered.
Elba
--
Not much remain to be said.

Filtered table using Countif
 

Have a look in Excel Help for the SUBTOTAL worksheet function.

I don't know what " ... vigen contidion ... " means.

Hope this helps.

Pete

On Jun 23, 3:37*pm, Elba wrote:
I have an excel spread sheet table that I filter. I would like to be able to
countif the number of cells in the filtered data to the vigen contidion.
Anyone know how to do this?
Countif returns the number of cells in the unfiltered data, even when they
are filtered.
Elba
--
Not much remain to be said.

Filtered table using Countif
 

Hi Pete_UK and Don Guillet, thanks for you response, but SUBTOTAL doesn't
have "COUNTIF" see below:

Function_num (includes hidden values) Function_num (ignores hidden values)
Function
1 101 AVERAGE
2 102 COUNT
3 103 COUNTA
4 104 MAX
5 105 MIN
6 106 PRODUCT
7 107 STDEV
8 108 STDEVP
9 109 SUM
10 110 VAR
11 111 VARP

vigen contidion: sorry misspelled, "given condition" or criteria

=COUNTIF(A1:A35,"criteria")

This formula counts the number of cells in the filtered data even when they
are filtered.

Thanks in advance,

Elba
--
Not much remain to be said.

Filtered table using Countif
 

Assume the full unfiltered data range is B2:B11. B1 is the column header
with filter.

Suppose you want to count the number of "A's" in column B:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B2:B11,ROW(B2:B11)-ROW(B2),0,1)),--(B2:B11="A"))

--
Biff
Microsoft Excel MVP


"Elba" wrote in message
...
I have an excel spread sheet table that I filter. I would like to be able
to
countif the number of cells in the filtered data to the vigen contidion.
Anyone know how to do this?
Countif returns the number of cells in the unfiltered data, even when they
are filtered.
Elba
--
Not much remain to be said.

Filtered table using Countif
 

Mr. T Valko, thanks so much for your help, my knowledge of english and excel
formula's is limited, but this formula works perfectly, perfectly, perfectly
fine.

Thanks again for your help.

Elba
--
Not much remain to be said.

Filtered table using Countif
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Elba" wrote in message
...
Mr. T Valko, thanks so much for your help, my knowledge of english and
excel
formula's is limited, but this formula works perfectly, perfectly,
perfectly
fine.

Thanks again for your help.

Elba
--
Not much remain to be said.