Array Formula

aweinberger

New Member
Joined
Oct 27, 2006
Messages
4
So, I was trying to use an array formula like used in the tip posted on this site. http://www.mrexcel.com/tip011.shtml

My need is a little more complicated. In the example,
sum(a2:a10*b2:b10) added the products of each respective row, using the CSE or array function.

In my case, I would like to do this, but have different categories, and would therefore like to use a sumif instead of a sum. Is this possible
 

Some videos you may like

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Bob Rooney

Board Regular
Joined
Jul 25, 2006
Messages
169
SUMIF will probably not work. To do what you wish, a common approach would be to use SUMPRODUCT, or an array-entered SUM(...) function call. Please provide more details so that a good answer can be offered.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
So, I was trying to use an array formula like used in the tip posted on this site. http://www.mrexcel.com/tip011.shtml

My need is a little more complicated. In the example,
sum(a2:a10*b2:b10) added the products of each respective row, using the CSE or array function.

In my case, I would like to do this, but have different categories, and would therefore like to use a sumif instead of a sum. Is this possible

Why don't you describe in full the problem you want to solve?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,993
Messages
5,545,378
Members
410,679
Latest member
rolandbianco
Top