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
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
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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks