Solved

excel frmulas

Posted on 2014-03-30
158 Views
Hello,

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

thank you
0
Question by:Rayne
• 3
• 2

LVL 26

Expert Comment

ID: 39964808
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

Author Comment

ID: 39964822

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

LVL 26

Accepted Solution

ID: 39964835
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

Author Comment

ID: 39964859
This is Freaking Awesome. Thank you MacroShadow :)
0

LVL 26

Expert Comment

ID: 39964983
0

Featured Post

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
No matter the version of Windows you are using, you may have some problems with Windows Search running too slow or possibly not running at all. Before jumping into how you can solve this issue, just know there are many other viable alternative deskt…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.