How about something like this...
C8:
=SUM(INDEX(B2:B8,MATCH(TRUE,A2:A833,0)):B8)
E8:
=SUM(INDEX(B1:B8,MATCH(TRUE,A1:A833,0)):B8)
Both these formulas need to be confirmed with CONTROL+SHIFT+ENTER, not
just ENTER.
Hope this helps!
In article ,
Robert wrote:
OKAY !
Im gonna try to explain in more detail!
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"
Thanks .. Robert
pacrat2001 <at msn <dot com
|