On 2002-09-20 12:00, JohnG wrote:
Tried that and got a lot of sub totals.
My test filter data is
TYPE DESC QTY
A THINGS 4
B THINGS 2
A THINGS 4
B THINGS 2
A THINGS 4
B THINGS 5
So if I filter TYPE on A's I want to have a counter respond that there are 3 of them.
On 2002-09-20 12:03, Mark W. wrote:
On 2002-09-20 12:00, JohnG wrote:
Tried that and got a lot of sub totals.
My test filter data is
TYPE DESC QTY
A THINGS 4
B THINGS 2
A THINGS 4
B THINGS 2
A THINGS 4
B THINGS 5
So if I filter TYPE on A's I want to have a counter respond that there are 3 of them.
Enter the formula once... not on every row of your data list.