# 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