# Array Formula

#### aweinberger

##### New Member
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

### 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
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
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?

#### aweinberger

##### New Member
how do i post a spreadsheet in the message?

#### Bob Rooney

##### Board Regular
Workbook sent to OP privately.

Replies
1
Views
36
Replies
6
Views
53
Replies
2
Views
18
Replies
7
Views
41
Replies
1
Views
185

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