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
John replied to mary on 20-Nov-10 01:43 AM