count a filtered sheet

[ProteanBeing]

I have a sheet that I filtered one column (A). Another column (B) has TRUE/FALSE data in it. I would like to be able to count the number of TRUEs in the filtered list. How do you do this?

[Simon Lloyd]

Try this:

=SUMPRODUCT(($B$1:$B$100=TRUE)*(SUBTOTAL(3,OFFSET($B$1,ROW($B$1:$B$100)-MIN(ROW($B$1:$B$100)),,))))

if you havent filtered your data it will show the total amount if you hide a row it has no effect it still shows the total amount if you filter your data it will show the total of visible TRUE's.

You can thank xld for showing me the path to enlightenment on this one!