Is there a way to use `SUMPRODUCT`

or use an array formula with arrays of differing sizes?

Currently I have a list of ~1500 products in column `A`

and columns `B`

-`I`

contain their respective component needs like so:

```
A B C D E F G H I J
¢20 ¢55 ¢75 ¢61 ¢12 ¢30 ¢46 ¢83 total
wdgt 9 1 1 0 0 0 0 0 235
fzzy 0 0 10 9 3 1 1 0 1411
sqr 10 10 10 10 10 10 10 10 3820
llc 2 4 6 8 10 12 14 16 3650
dbl 2 4 8 16 32 64 128 256 31276
....
```

Each of the respective components has a set value , and `J`

is currently calculated by

```
SUMPRODUCT(B2:I2,$B1:$I1)...
```

I would like to have `J`

be an array formula like

```
{=SUMPRODUCT(B2:I6,$B1:$I1)}
```

but doing so gives #VALUE! error and:

```
{=SUM(B2:I6,$B1:$I1)}
```

for each row i.e. the sum of the total column, 40392.

Is there a way to do this with an array formula?

`B`

and`I`

absolute, but not the row numbers? And, just for good measure, what version of Excel are you using? – G-Man Aug 25 '14 at 22:55