I have a formula adding (for example) a1+ b2, a2+b3, a3 +b4 ect ect.

A B

1 3 7

2 10 14

3 5 11

4 13 2

5 4 6

if I filter column A in the above example to cells less than "10' the example would look like this:

A B

1 3 7

3 5 11

5 4 6

what I am trying to do is sum first cell in row 1 column1 with row 2 column 2 in the filtered data.

so formula would calculate this:

a1+b3, a3 + B6 ect ect.

hopefully i have explained this clearly.

any help would be much appreciated = )