LinkBack URL
About LinkBacks
hi. this is my problem, please help me a solution for this.
how do i combine / sum sheets and make a summary into another sheet. taking the DESC as the point reference to achieve the output?
excel.jpg
Thank you. any help will be appreciated.
hi. this is my problem, please help me a solution for this.
how do i combine / sum sheets and make a summary into another sheet. taking the DESC as the point reference to achieve the output?
excel.jpg
Thank you. any help will be appreciated.
Last edited by arrows101; 05-26-2012 at 04:39 PM.
will the values only appear once on each sheet?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
[QUOTE=FDibbins;2803029]will the values only appear once on each sheet?[/QUOT
no sir some values may appear twice or more on each sheet. thats what i want to summarize on the last sheet.
say
sheet a - with values "2 a c" qty 2 and 4
with value "4 b a" qty 4
sheet b - with values "3 e a" qty 3 and 5
and summary will be like this
final sheet = 2 a c qty 6
4 b a qty 4
3 e a qty 8
same values will sum up
hope im right understanding your question.
yes, you understood, thx for the update
edit:
how many sheets are we talking about here?
Last edited by FDibbins; 05-26-2012 at 07:45 PM.
12 sheets 1 for each month. i just sample a 3-month period.
im sure some1 can come up with a far less messy way of doing this, but right now, i cant think of a cleaner way...
=SUM(SUMIF(a!$B$6:$B$25,summary!B6,a!$C$6:$C$25),SUMIF(b!$B$6:$B$25,summary!B6,b!$C$6:$C$25),SUMIF('c'!$B$6:$B$25,summary!B6,'c'!$C$6:$C$25))
you will need to add the other sheets that you need to that though
thanks gonna try it. ill post back. thanks --
all returned 0 values. do you mind doing it on the attached xls file. please sir.
see the attched, based on your file
excellent. thank you sir. but how do i capture the DESC and put is beside the value. i believe there will be another function to do that or/and associated with the sumif formula.Originally Posted by FDibbins
ok so you want the descoption AND the total to be shown in the same cell? if thats what you need, change the formula from...
=SUM(SUMIF(a!$B$6:$C$25,B6,a!$C$6:$C$25),SUMIF(b!$B$6:$C$25,B6,b!$C$6:$C$25),SUMIF('c'!$B$6:$C$25,B6,'c'!$C$6:$C$25))
to
=B6&" "&SUM(SUMIF(a!$B$6:$C$25,B6,a!$C$6:$C$25),SUMIF(b!$B$6:$C$25,B6,b!$C$6:$C$25),SUMIF('c'!$B$6:$C$25,B6,'c'!$C$6:$C$25))
sir, different cells for description and value.
ei,
desc qty
2 ac 4
ok, you already have the description in column B?
Hi aroows,
You could also use, C6 then copy down
Add the other sheet names between curly baraces {}
Please Login or Register to view this content.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks