Eddy,

Your do not have enough information to calculate what you want.

You have basically an infinite set of solutions. For example, the 300 for yr06 could be tariff 150
+ shortage 150, or it could be tariff 149.99, shortage 149.99 damage 0.02, ......


HTH,
Bernie
MS Excel MVP


"Eddy Stan" wrote in message
...
Hi all,
I have data in 500 rows of 15 columns
example
Total yr 05 yr06 yr07 tariff shortage damage wr blng old
1000 500 300 200 150 150 150 250 300
total = yr 05 + yr 06 + yr 07
total = tariff + shortage + damage + wr blng + old
i need formula to compute sum at xxxx (sum(if, sumproduct, or sumif( or any)
tariff shortage damage wr blng old
yr 05 xxxx xxxx xxx xxxx xxxx
yr 06 xxxx xxxx xxx xxxx xxxx
yr 07 xxxx xxxx xxx xxxx xxxx

thank u in advance