Forum Discussion
Solved
Help with counting the number of occurencies with filtered data
Good morning, I am trying to count the number of times the numbers 1, 2, & 3 appear in the RES column. (Screengrab attached) The data is filtered and is correctly showing 126 rows. I want...
In R8:
=SUMPRODUCT((T11:T100=1)*(SUBTOTAL(103, OFFSET(T11, ROW(T11:T100)-MIN(ROW(T11:T100)), 0))))Adjust the range T11:T100 as needed.
Similar for S8 and T8, with =2 and =3 instead of =1.
In R8:
=SUMPRODUCT((T11:T100=1)*(SUBTOTAL(103, OFFSET(T11, ROW(T11:T100)-MIN(ROW(T11:T100)), 0))))Adjust the range T11:T100 as needed.
Similar for S8 and T8, with =2 and =3 instead of =1.
I am now trying to get the info from Col BW - there are certainly more than two occurrences in that column. Any idea what is wrong Hans? (attached file)
Could you attach a small sample workbook without sensitive information that demonstrates the problem?
