• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 381
  • Last Modified:

Array formulas, can they be summed

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
ssmith94015
Asked:
ssmith94015
  • 2
2 Solutions
 
barry houdiniCommented:
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
 
Saqib Husain, SyedEngineerCommented:
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
 
ssmith94015Author Commented:
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
 
ssmith94015Author Commented:
Thank you for the information and alternatives in case I run into problems with what I have.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now