# Filtered column find <2 numbers

#### REALOLDMAN

##### New Member
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

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Hi
Welcome to the board

Try:

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

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

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

Since i said it worked do i repost?

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

Replies
16
Views
474
Replies
6
Views
382
Replies
11
Views
463
Replies
3
Views
144
Replies
3
Views
142

1,202,990
Messages
6,052,958
Members
444,621
Latest member
MIKOLAJ_R

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back