Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Array formulas, can they be summed

Posted on 2011-03-23
Medium Priority
379 Views
Is it possible to have mutiple array formulas in a cell and have them sum?  If so, how would this be done?  I have  a woksheet that needs to add several numbers, which are determined by array formuals.
0
Question by:ssmith94015
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 2

LVL 50

Accepted Solution

barry houdini earned 1000 total points
ID: 35202388
You'd probably want to use a different approach. Instead of this formula

You can use SUMPRODUCT like this

=SUMPRODUCT((DataSource!A3:A100=J1)*("AAA or Above"=DataSource!B3:B100),DataSource!C3:C100)

That will sum all the values in column C when the two criteria are met in columns A and B....or do you have other criteria too?

regards, barry
0

LVL 43

Assisted Solution

Saqib Husain, Syed earned 1000 total points
ID: 35202409
It would be helpful if you give sample data in a workbook.

Meanwhile here is an example of adding two array formulas

Saqib
0

Author Comment

ID: 35202549
Actually, I am surprised to see this question as I deleted it and I had, at that time, not see any responses.  I solved and YES! you can add two arrays.  It works perfectly.
0

Author Closing Comment

ID: 35202600
Thank you for the information and alternatives in case I run into problems with what I have.
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month12 days, 8 hours left to enroll