Hi,

I’m looking for the formula to have every cell that contains a specific word then add the result if the first cell of the row is Blank. So in the exemple I want to have the sum of all the apple where the first row ISBLANK

```
A B C D E
1 Apple 60 Orange 80
2 X Pear 50 Apple 70
3 Banana 30 Pear 25
4 X Apple 50 Banana 35
```

For now I have this

{=SUMIF(B1:D4,“Apple”,C1:E4)}

That gives 60+70+50=180 since it doesn’t look for the first blank column

But I tried multiple things like sumifs or nested if with the first column and it spreads the cells down or even worse multiple #504 errors

```
180
0
180
0
Err:504 Err:504 Err:504
Err:504 Err:504 Err:504
Err:504 Err:504 Err:504
Err:504 Err:504 Err:504
```

Any idea how to achieve this ?

cheers