Is it possible selecting the odd rows in a SUMIF function under the SUM_RANGE criteria?

[theo_c]

Hello, I have an excel worksheet divided in such a way:

\1

So I want to use the SUMIF function to Sum the numbers plugged under every "Huawei"... Therefore the function will look something like this: =SUMIF(B2:J17, "Huawei", [Sum_Range])

My question is what should I write instead of the [Sum_Range] so that the function sums the odd rows, which contains the numbers?

Thank You

[Jonmo1]

Try

=SUMIF(B2:J16,"Huawei",B3:J17)

[theo_c]

Wawww, what I thought was a complex problem turned out to be a simple one :P Thanks a lot Jonmo1, that solved it

[Jonmo1]

Glad to help,

Notice the key is the offset by 1 row between the criteriarange and the sumrange