conditional summing - help

[Eddy Stan]

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

 

[Bernie Deitrick]

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]

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]

Eddy,

I would first suggest a pivot table - the success of which will be dependent on your data table
layout. If you have used a database type entry, it will work wonders. Otherwise, post an exact
description of the layout of your fifteen columns, with example data, and what table you would
expect from that data.

HTH,
Bernie
MS Excel MVP