REALOLDMAN
New Member
- Joined
- Feb 5, 2019
- Messages
- 12
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
=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