On Sat, 12 Mar 2005 11:58:14 +0800, "Max"
wrote:

"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:

I have also done this myself, this one would work too, except I need
to add 1 more function to this, then it no longer works. Only 7
functions are allowed per cell.
=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(A 833,B8,0)))))))

Copy C8 down

Put in E8:

This one has 8 functions, as I said above, Only 7 functions allowed
per cell.
=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(A 733,SUM(B7:B8),IF(A833,B8
,0))))))))

Copy E8 down


Thanks for your input ... Robert