Hi,
Sorry for my wrong question.
The year sum is already split into reason wise, based on figures in documents.
let me give the year wise total and reason wise total separately.
Any logical splitting will give wrong picture only.
thank you for opening eyes.


"Bernie Deitrick" wrote:

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