Solved: worksheets functions

[ProteanBeing]

I know that this is not a VBA question but I need to count the number of X's in a filtered column. Is this possible?

[JKwan]

Is this what you mean?
http://puremis.net/excel/code/085.shtml

[Bob Phillips]

Assuming you have Excel 2003, you can use Subtotal

=SUBTOTAL(103,J1:J8)

on the basis that only the X is showing.

[ProteanBeing]

It's actually True and False. How do I count the True's?

[Bob Phillips]

I don't get it, what did you filter on then?

[ProteanBeing]

I filtered on date. Sorry didn't think of doing another filter til now. :doh:

[rory]

You can do it without the additional filter but the formula gets pretty ugly!