Microsoft Excel - sum quantity from summary to final summary

Asked By John on 14-Nov-10 06:09 AM
Good Day


This is my excel sheet Book1.zip
I want to make final summary from summary sheet.  I want to sum total Internal panels for all blocks to final summary. Can I use sumif command to do this ? Can anyone help me to find a solution.
mary replied to John on 14-Nov-10 08:17 AM
Here you go John


=SUMIF(summary!B6:B53,"*internal*",summary!C6:C53)
mary replied to John on 14-Nov-10 08:22 AM
sorry i read the question incorrectly.

=SUMIF(summary!$B$6:$B$53,"*Internal Panel Wall*",summary!$C$6:$C$53) 
=SUMIF(summary!B6:B53,"*Internal column*",summary!$C$6:$C$53)

And so on
John replied to mary on 15-Nov-10 01:46 AM

Sorry this formula not working? Can you please check it again. Some error showing
John replied to mary on 15-Nov-10 01:46 AM

Sorry this formula not working? Can you please check it again. Some error showing
John replied to mary on 15-Nov-10 01:53 AM
 In my sample excel file  column U , I put A,B,C,D,E,F  A for all  Internal Panel B for Internal column bcause in the summary sheet I added different names. Please check my sample excel file (zip) and please give me a correct fomat
John replied to mary on 15-Nov-10 03:19 AM

Sorry I change the command as like below and now its working

=SUMIF(SUMMARY!$U$6:$U$53,"*A*",SUMMARY!$C$6:$C$53)


Thanks alot
mary replied to John on 15-Nov-10 07:37 PM
JOHNS FILE.zip

John, see formulas in file
John replied to mary on 20-Nov-10 01:43 AM
Thank you so much