Hi,

I have 2 horizontal arrays starting from the cell A1 as below -

```
3 4 5 6
2 3 4 56
```

Now I want to use the `SUMIF()`

function to calculate the sum of the 2nd row when value of the1st row matches with a particular value. I used below -

```
=SUMIF(A2:D2, A1:D1, "="&5)
```

However with above formula, I get error as

```
Err:504
```

Can you please help to find the right approach for above data. My arrays are always horizontal, not vertical.

Any pointer will be highly appreciated.