Excel Magic Trick 857: SUMIF Function with Sheet References: Summarize Data From Different Sheet

Download from: http://people.highline.edu/mgirvin/ExcelIsFun.htm
1. See how to use the SUMIF function and Sheet References to summarize data from a different sheet.
2. Add with One Criteria: SUMIF Function

Category:

Education

Tags:

• Excel
• 2003
• 2010
• 2007
• Mike
• Girvin
• excelisfun
• Highline
• Community
• College
• See
• how
• to
• use
• the
• SUMIF
• function
• and
• Sheet
• References
• summarize
• data
• from
• different
• sheet
• Add
• with
• One
• Criteria:
• Function

[ExcelIsFun]

krn14242 , Yes, quite amazing!

[ExcelIsFun]

66437473 , cool1 i am glad that you like it!

[ExcelIsFun]

sperdoch , in cell B5 put formula: =SUM(B2:B4). Then in cell C2 put forumla: = B2/$B$5 and copy it down. That will yield the percentages.

[ExcelIsFun]

zamannoun , you are welcome!

[krn14242]

Thanks Mike, I see what you mean about more people viewing the basics.

[66437473]

grate tip. Thanks

[sperdoch]

Nice tip. Is there an easy/efficient way to show the percentages of cost for all 3? So for example, Column C could be labeled "Percentage" and then "Aldo would represent 45%

[zamannoun]

thank you very much....

I'm inviting you to an unforgettable meal if you came to Jordan!!!!!

Thanks a lot my friend.