Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional summing - help
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional summing - help
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional summing - help
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional summing - help
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 "Eddy Stan" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional summing | Excel Worksheet Functions | |||
Conditional Summing... | Excel Worksheet Functions | |||
Conditional Summing | Excel Discussion (Misc queries) | |||
"Conditional" summing | Excel Worksheet Functions | |||
conditional Summing | Excel Worksheet Functions |