PDA

View Full Version : count a filtered sheet



ProteanBeing
02-06-2008, 10:25 AM
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
02-06-2008, 11:10 AM
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!