SUMIF when range and sum_range are in alternating columns

[jojo1]

Hi Please help
I got 4 rows, 8 columns table, so my range in 8 alternating columns, and my sum_range is in another 8 alternating columns.
SUMIF
( range, B3;B7, D3;D7, F3;F7
criteria, S4
[sum_range] ) C3;C7, E3;E7, G3;G7


is it any way to write this =SUMIF(B3:B7,S4,C3:C7)+SUMIF(D3:D7,S4,E3:E7)+SUMIF(F3:F7,S4,G3:G7) in different way?

thank you

[tim201110]

=sum((((mod(column(b3:g7),2)=0)*(b3:g7=s4))*(mod(column(b3:g7),2)=1)*b3:g7))

[XOR LX]

=sum((((mod(column(b3:g7),2)=0)*(b3:g7=s4))*(mod(column(b3:g7),2)=1)*b3:g7))

Hi.

Did you test your solution before posting?

Regards

[jojo1]

thank you.
Probably I should say that my range columns and criteria are text(name of customer) and only sum-range columns are numbers that I need
to sum (number of hours)
and maybe that's why it didn't work ???

[XOR LX]

is it any way to write this =SUMIF(B3:B7,S4,C3:C7)+SUMIF(D3:D7,S4,E3:E7)+SUMIF(F3:F7,S4,G3:G7) in different way?

Hi.

You may be able to get away with simply:

=SUMIF(B3:F7,S4,C3:G7)

though this is contingent on their being no pairs of entries in which your criterion (C4) also happens to occur in one of the desired sum_range columns and the value in the next column in the corresponding row is a numerical.

Regards

[jojo1]

Hi.

You may be able to get away with simply:

=SUMIF(B3:F7,S4,C3:G7)

though this is contingent on their being no pairs of entries in which your criterion (C4) also happens to occur in one of the desired sum_range columns and the value in the next column in the corresponding row is a numerical.

Regards

oh wow so simple
thank you so much, it's working.

[XOR LX]

You're welcome!

[Jonmo1]

NM, already solved in the same way..