Excel Array Formula Series #1: Basics of Array Formulas

See how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by Excel

See how to calculate the Total Sales (given rows of input data)

In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.

Category:

Science & Technology

Tags:

• Excel
• Array
• Formulas
• functions
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[jamiezzj]

thumb upppp thanks mark!

[ExcelIsFun]

@jamiezzj , You are welcome!

[velcrots]

hey guys, here's a tough one...i'm making a daily nutritional intake chart. say column 1 says "oatmeal", column 2 has the # of calories, 3 has # of carbs, 4 has # of fat...etc.  how can i make the word "oatmeal", say in dropdown list on another worksheet, represent all of those columns of data? and once selected, that data shows up in seperated columns in a results table, to sum with other data from other dropdowns? have i described it so it makes sense? is it even possible? thanks so much!

[ExcelIsFun]

@velcrots , pots Q to:

mrexcel [dot] com/forum

[TheUkrgrl]

THANK YOU!! I've been trying to figure out this array name thing for hours, and halfway into your video, I got it!

[ExcelIsFun]

@TheUkrgrl , cool! I have a playlist og videos that goes into even more detail:

youtube.com/user/ExcelIsFun#gr­id/user/007E7E9CA63304D3

[ExcelIsFun]

@sdamoney , u r welcome!

[sdamoney]

thanks for being upbeat or else I'd be bored!

[ExcelIsFun]

You are welcome!

[browncone]

very helpful thank you for helping me to understand a better way to array formulas in excel!