Filtered column find <2 numbers

[REALOLDMAN]

TRIED TO ATTACH A SNAP SHOT NO LUCK
=SUBTOTAL(3,OFFSET(A4:A13,ROW(A4:A13)-MIN(ROW(A4:A13)),1)) MY FILTER THIS WORKS
=SUMPRODUCT(SUBTOTAL(3,OFFSET(C4:C12,ROW(C4:C12)-MIN(ROW(C4:C12)),,1))--(C4:C12="<2")) NO LUCK
FLITERED
v
1 A B C D
2 C 1 ALL 1-16
3 N 9
4 ETC 2
5 ETC
6
7
8
9
10
11
12
13

 

[pgc01]

Hi
Welcome to the board

Try:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(C4:C12,ROW(C4:C12)-MIN(ROW(C4:C12)),,1)),--(C4:C12<2))

 

[REALOLDMAN]

WORKS THANK YOU VERY MUCH
i HAD SUMPRODUCT BUT IT DID NOT WORK ETHER
i DON'T KNOW EXCEL WELL SO i THINK I USUALLY ASK THE WRONG QUESTION
NOT SHOUTING EYES NOT AS GOOD WHEN 20

 

[REALOLDMAN]

Jumped the gun wrong results
worked on col but off when going c d e f etc
how do i show my table without recreate with note

 

[REALOLDMAN]

Since i said it worked do i repost?

 

[REALOLDMAN]

found a fix but I could not find a reply that said you did in my email
thank you again