excel frmulas

Hello,

Why would use array formulas over sumproducts/sumifs or any summing formulas? or vice versa?

thank you
RayneAsked:
Who is Participating?
 
MacroShadowCommented:
As Chip Pearson put it:
There are two flavors of array formulas: first, there are those formulas that work with an array or series of data and aggregate it, typically using SUM, AVERAGE, or COUNT, to return a single value to a single cell. In this type of array formula, the result, while calculated from arrays, is a single value. We will examine this type of array formula first. The second flavor of array formulas is a formula that returns a result in to two or more cells. These types of array formulas return an array of values as their result.
you should find his article on array formulas most enlightening.
0
 
MacroShadowCommented:
Array formulas have many uses, many of which summing formulas won't work.

If you have a specific question about which formula to prefer, please post you're formulas.
0
 
RayneAuthor Commented:
Hello Macroshadow,

I don't have any specific formulas or situation that i can relate to - it would be great if can you provide some examples if you have?

thank you
0
 
RayneAuthor Commented:
This is Freaking Awesome. Thank you MacroShadow :)
0
 
MacroShadowCommented:
Glad to help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.