Solved

Array formulas, can they be summed

Posted on 2011-03-23
4
374 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
[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
  • Learn & ask questions
  • 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

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…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

688 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