Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a sum of values from multiple sheets
How can we get sum of values from multiple sheets which it shows in a new or
specific sheet and in next cell i need the discription of that vaule too... which will be same in all sheets... but cells will be different. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a sum of values from multiple sheets
Hi
could you provide more details: where are your cells on the individual sheets - do you have a list of the sheet names or are they following a naming convetion ..- some example data "Ahmed" wrote: How can we get sum of values from multiple sheets which it shows in a new or specific sheet and in next cell i need the discription of that vaule too... which will be same in all sheets... but cells will be different. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a sum of values from multiple sheets
on first sheed "DATA" i have all the details of my products with Product codes.
then next on multiiple sheets i have my company orders .. where i have used vlookup then i enter qty i order... and on next column i have received qty and then pending qty... now i need a summary on the end sheet of all pending products... where i want to have Product name, then sum of all pending qty in front of it... thats all i want to do... "Frank Kabel" wrote: Hi could you provide more details: where are your cells on the individual sheets - do you have a list of the sheet names or are they following a naming convetion .- some example data "Ahmed" wrote: How can we get sum of values from multiple sheets which it shows in a new or specific sheet and in next cell i need the discription of that vaule too... which will be same in all sheets... but cells will be different. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a sum of values from multiple sheets
Hi
as said: How are the individual sheets named. also post some real example data. "Ahmed" wrote: on first sheed "DATA" i have all the details of my products with Product codes. then next on multiiple sheets i have my company orders .. where i have used vlookup then i enter qty i order... and on next column i have received qty and then pending qty... now i need a summary on the end sheet of all pending products... where i want to have Product name, then sum of all pending qty in front of it... thats all i want to do... "Frank Kabel" wrote: Hi could you provide more details: where are your cells on the individual sheets - do you have a list of the sheet names or are they following a naming convetion .- some example data "Ahmed" wrote: How can we get sum of values from multiple sheets which it shows in a new or specific sheet and in next cell i need the discription of that vaule too... which will be same in all sheets... but cells will be different. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a sum of values from multiple sheets
this is the data 1st code ...then description
552405 type E91 N B06 6A 552407 type E91 N B10 10A 552409 type E91 N B16 16A 552410 type E91 N B20 20A this is order sheet with vlookup 6-digit Ref # Description Qty Receiveed Pending 552787 - - type E91 C03 3A 108 100 8 552789 - - type E91 C06 6A 600 445.00 155 552796 - - type E91 C32 32A 300 300.00 0 Here we need output this way CODE PRODUCT DESCRIPTION TOTAL PENDING QTY 552787 type E91 C03 3A 8 thats it... "Frank Kabel" wrote: Hi as said: How are the individual sheets named. also post some real example data. "Ahmed" wrote: on first sheed "DATA" i have all the details of my products with Product codes. then next on multiiple sheets i have my company orders .. where i have used vlookup then i enter qty i order... and on next column i have received qty and then pending qty... now i need a summary on the end sheet of all pending products... where i want to have Product name, then sum of all pending qty in front of it... thats all i want to do... "Frank Kabel" wrote: Hi could you provide more details: where are your cells on the individual sheets - do you have a list of the sheet names or are they following a naming convetion .- some example data "Ahmed" wrote: How can we get sum of values from multiple sheets which it shows in a new or specific sheet and in next cell i need the discription of that vaule too... which will be same in all sheets... but cells will be different. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a sum of values from multiple sheets
Sheet names are
PO #108 PO #109 PO #110 PO #112 PO #115 PO #117 "Ahmed" wrote: How can we get sum of values from multiple sheets which it shows in a new or specific sheet and in next cell i need the discription of that vaule too... which will be same in all sheets... but cells will be different. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get a sum of values from multiple sheets
Hinot fully sure but you may try the following formula:
=SUMPRODUCT(SUMIF(INDIRECT("'PO #" & ROW(INDIRECT("108:117")) & "'!A1:A100"),A1,INDIRECT("'PO #" & ROW(INDIRECT("108:117")) & "'!F1:F100"))) with the following assumption: - you have the sheets "PO #108" to "PO #117" and they are named in exact this way: - A1 on your oder sheet contains the 6-digit number you want to lookup on the individual PO # sheets. You have entered this value manually - column A on these PO # sheets also conatins this 6-digit number - column F on the iondividual sheets contains the pending amount/value which is to be summed f this does not work you may email me an example sheet at frank[dot]kabel[at]mummert[dot]de General note: I wouldn't use Excel in this way for such Analysis. Sounds more like a database task for me "Ahmed" wrote: this is the data 1st code ...then description 552405 type E91 N B06 6A 552407 type E91 N B10 10A 552409 type E91 N B16 16A 552410 type E91 N B20 20A this is order sheet with vlookup 6-digit Ref # Description Qty Receiveed Pending 552787 - - type E91 C03 3A 108 100 8 552789 - - type E91 C06 6A 600 445.00 155 552796 - - type E91 C32 32A 300 300.00 0 Here we need output this way CODE PRODUCT DESCRIPTION TOTAL PENDING QTY 552787 type E91 C03 3A 8 thats it... "Frank Kabel" wrote: Hi as said: How are the individual sheets named. also post some real example data. "Ahmed" wrote: on first sheed "DATA" i have all the details of my products with Product codes. then next on multiiple sheets i have my company orders .. where i have used vlookup then i enter qty i order... and on next column i have received qty and then pending qty... now i need a summary on the end sheet of all pending products... where i want to have Product name, then sum of all pending qty in front of it... thats all i want to do... "Frank Kabel" wrote: Hi could you provide more details: where are your cells on the individual sheets - do you have a list of the sheet names or are they following a naming convetion .- some example data "Ahmed" wrote: How can we get sum of values from multiple sheets which it shows in a new or specific sheet and in next cell i need the discription of that vaule too... which will be same in all sheets... but cells will be different. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Values in multiple sheets | Excel Discussion (Misc queries) | |||
SUM VALUES on MULTIPLE SHEETS | Excel Worksheet Functions | |||
subtracting multiple values between sheets | Setting up and Configuration of Excel | |||
searching and collating values in multiple sheets | Excel Discussion (Misc queries) | |||
Weighted Avg - using values from multiple sheets | Excel Worksheet Functions |