06-03-2002, 11:27 AM

Column A has list of names- some repeating.

Cloumn B has 'Y' and 'N' only beside each name

If I filter on a name in A I want to total from column B how many Y's there are.

tried Subtotal above the column but cant work it to exclude the N's. have resorted to adding a hidden column next to b and assigning 1 for Y and 0 for N and then subtotalling (sum) of this column- is there a way I can avoid this?

Cloumn B has 'Y' and 'N' only beside each name

If I filter on a name in A I want to total from column B how many Y's there are.

tried Subtotal above the column but cant work it to exclude the N's. have resorted to adding a hidden column next to b and assigning 1 for Y and 0 for N and then subtotalling (sum) of this column- is there a way I can avoid this?