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.
Sandra SmithRetiredAsked:
Who is Participating?
 
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
 
Sandra SmithRetiredAuthor 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
 
Sandra SmithRetiredAuthor Commented:
Thank you for the information and alternatives in case I run into problems with what I have.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.