I have a problem. I have a worksheet with a in column A names, in column B team numbers and in the columns behind those names I have B's, M's, numbers and blanks. I want to be able to filter on the teams column and then count the amount of numbers in a certain column. So far I built this formula:



=(SUMPRODUCT(SUBTOTAL(3,OFFSET(GY10:GY1048576,ROW( GY10:GY1048576)-MIN(ROW(GY10:GY1048576)),,1)),--(GY10:GY1048576>1)))

But it sees the B's and the M's as a value greater than 1 aswell
How do I fix this?

I hope someone can help me!

Try:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(GY10:GY1048576,ROW(G Y10:GY1048576)-MIN(ROW(GY10:GY1048576)),,1)),(GY10:GY1048576>1)*I SNUMBER((GY10:GY1048576)))

Thank you for your quick reply!
It worked! (after I found out I had to remove 2 spaces because I got #NAME?)

Thank you very very much!

ooops.... that's a forum glitch that added the space in "ISNUMBER". Sorry..

Doesn't matter, I figured it out

One more question: What would the formula be if I wanted to count the B's and M's in the same column with filters?

Try:

Thank you! Much easier to fix than I was thinking haha