Solved

Array formulas, can they be summed

Posted on 2011-03-23
4
367 Views
Last Modified: 2012-05-11
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
Comment
Question by:ssmith94015
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 250 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

by:Saqib Husain, Syed
Saqib Husain, Syed earned 250 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
Adding-array-formulas.xls
0
 

Author Comment

by:ssmith94015
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

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

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Many companies are making the switch from Microsoft to Google Apps (https://www.google.com/work/apps/business/). Use this article to learn more about what Google Apps has to offer and to help if you’re planning on migrating to Google Apps. It is …
Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now