PDA

View Full Version : Solved: worksheets functions



ProteanBeing
01-03-2008, 08:42 AM
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
01-03-2008, 08:46 AM
Is this what you mean?
http://puremis.net/excel/code/085.shtml

Bob Phillips
01-03-2008, 08:47 AM
Assuming you have Excel 2003, you can use Subtotal

=SUBTOTAL(103,J1:J8)

on the basis that only the X is showing.

ProteanBeing
01-03-2008, 08:52 AM
It's actually True and False. How do I count the True's?

Bob Phillips
01-03-2008, 09:05 AM
I don't get it, what did you filter on then?

ProteanBeing
01-03-2008, 09:11 AM
I filtered on date. Sorry didn't think of doing another filter til now. :doh:

rory
01-03-2008, 09:39 AM
You can do it without the additional filter but the formula gets pretty ugly!