Thankyou Harlan,

You really know your stuff with the programing language. I wish I knew more. Can you possibly suggest
anything that can help me out? I am a visual learner, I can pick some up by reading too but I do not retain it as
well.

I tried your formula and it works fabulously, can you help me with another area? I am trying to merge what u
wrote in combination with the following

The formula u gave me is for Cell G11, I am trying to merge this example 1 cell at a time as it goes up in numbers
=IF(C1233,D12,

Cell G12 : =IF(C1233,D12,IF(D11=0,SUM(D10:D12),IF(D10=0,SUM( D11:D12),IF(D9=0,SUM(D10:D12),IF(D9=0,SUM(D8:D12), IF(D8=0,SUM(D7:D12),IF(D7=0,SUM(D6:D12),IF D6=0,SUM(D5:D12),SUM(D6:D12)))))))))

Cell G13 :
=IF(C1333,D13,IF(C1233,SUM(D12:D13),IF(D11=0,SUM (D12:D13),IF(D10=0,SUM(D11:D13),IF(D9=0,SUM(D10:D1 3),IF(D8=0,SUM(D9:D13),IF(D7=0,SUM(D8:D13),IF(D6=0 ,SUM(D7:D13),SUM(D6-D13)))))))

Cell G14 :
=IF(C1433,D14,IF(C1333,SUM(D13:D14),IF(C1233,SU M(D12:D14),IF(D11=0,SUM(D12:D14),IF(D10=0,SUM(D11: D14),IF(D9=0,SUM(D10:D14),IF(D8=0,SUM(D9:D14),If(D 7=0,SUM(D8:D14),SUM(D7:D14)))))))))

etc ... thru G19 where all the remaining cell will have the same formula using " =IF(C1233,D12, "

I wish there were a way for you to see what I am working on so that you could better understand it.

Anyway, Thanks for your help !

SUB-ZERO


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-