"Robert" wrote in message
.....
Column C only goes back 7 rows.
Lets say, for C8 I need for it to look from A8:A2 for
any number above 33.

(For Cell C8)
Example "If A2 is Greater than 33, I need for it to sum B2:B8."
Example "If A3 is Greater than 33, I need for it to sum B3:B8"
Example "If A4 is Greater than 33, I need for it to sum B4:B8"
Example "If A5 is Greater than 33, I need for it to sum B5:B8"
Example "If A6 is Greater than 33, I need for it to sum B6:B8"
Example "If A7 is Greater than 33, I need for it to sum B7:B8"
Example "If A8 is Greater than 33, I need for it to sum only B8"


Column E goes back 8 rows.
Lets say, for E8, I need for it to look at A8:A1 for
any number above 33.

(For Cell E8)
Example " If A1 I need for it to sum B1:B8."
Example " If A2 is Greater than 33, , I need for it to sum B2:B8"
Example " If A3 is Greater than 33, , I need for it to sum B3:B8"
Example " If A4 is Greater than 33, , I need for it to sum B4:B8"
Example " If A5 is Greater than 33, , I need for it to sum B5:B8"
Example " If A6 is Greater than 33, , I need for it to sum B6:B8"
Example " If A7 is Greater than 33, , I need for it to sum B7:B8"
Example " If A8 is Greater than 33, , I need for it to sum B8"

Here's my best shot at it ..

Put in C8:

=IF(A233,SUM(B2:B8),IF(A333,SUM(B3:B8),IF(A433, SUM(B4:B8),IF(A533,SUM(B5
:B8),IF(A633,SUM(B6:B8),IF(A733,SUM(B7:B8),IF(A8 33,B8,0)))))))

Copy C8 down

Put in E8:

=IF(A133,SUM(B1:B8),IF(A233,SUM(B2:B8),IF(A333, SUM(B3:B8),IF(A433,SUM(B4
:B8),IF(A533,SUM(B5:B8),IF(A633,SUM(B6:B8),IF(A7 33,SUM(B7:B8),IF(A833,B8
,0))))))))

Copy E8 down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----