Counting a Filtered Dataset
 

In the same way the Subtotal Function sums a filtered dataset I need a
function
which counts the values within a filtered dataset.

Many Thanks


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=401935

Hi T De Villiers,

Not only the Subtotal Function sums and counts data in a filtered dataset,
but it multiplies, averages up, gets min, max, etc. It is just a question of
what is the first argument in the function:

1 AVERAGE

2 COUNT

3 COUNTA

4 MAX

5 MIN

6 PRODUCT

7 STDEV

8 STDEVP

9 SUM

10 VAR

11 VARP


Try: =SUBTOTAL(2,A2:A100)

Regards,
KL


"T De Villiers"
wrote in message
news:T.De.Villiers.1uw5mc_1125932729.5738@excelfor um-nospam.com...

In the same way the Subtotal Function sums a filtered dataset I need a
function
which counts the values within a filtered dataset.

Many Thanks


--
T De Villiers
------------------------------------------------------------------------
T De Villiers's Profile:
http://www.excelforum.com/member.php...o&userid=26479
View this thread: http://www.excelforum.com/showthread...hreadid=401935