I have a specific problem like following:

As you can see I have 3 cells in which I have "Total" value of something.

I'd like to sum all of these values below, in whichever column there's a text that matches the word "Total".

So for instance there are 3 columns that contain word "Total" right now, and I'd like to sum their values below them which are:

```
1500, 11223 and 11220
```

I've tried using the sumif function in Excel, but for some reason it seems to be able only to sum a range of columns, not range of multiple rows...

I tried this:

```
=SUMIF(A2:AJ2,"*Total*",B3:AJ3)
B3:AJ3 are colums right below these upper ones...
```

Edit: The total value that I should get is 23943

`$N1=$D1+$G1+$L1`

– Raystafarian Oct 12 '16 at 11:36