SUMIF across multiple cells

[RodneyW]

I'm using the following SUMIF statement: =SUMIF(G10:G22,"x",F10:F22) and it's working perfectly.

Now what I need in cell U10 is a formula that will look at cell G10. If the value is "x" then U10 will display the value in cell E10 ----- AND ----- at the same time I need it to look in cell K10. If the value is "x" then I need cell U10 to add the value in cell I10 and so on for O10 when it equals "x" to add the value in M10 and when S10 = "x" to add the value in Q10.

In non-code language I would say my destination cell us U10. Look at the following
If G10 = x then include the value in E10 in the sum. Also look at K10, if it equals "x" than include the value in I10 in the sum. Also look at O10, if it equals "x" than include the value in M10 in the sum. Also look in cell S10, if it equals "x" then include that value in the sum.

thanks in advance

 

[Ron Coderre]

Assuming your values are evenly spaced....
In this example, the formula is referencing E10:O10
which contains these values:
E10 100
G10 x
I10 200
K10 x
M10 500
O10x

This formula, in U10 returns the sum of the x-associated values:
=SUMIF(G10:O10,"x",E10:M10)

Note the staggered range references.

In that example, the formula returns 800

Is that something you can work with?

 

[RodneyW]

about to jump on a conference call.... will check when it's over. TY