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!