adding non-adjacent cells depending on another cell

Originally Posted by daddylonglegs

You can try this formula for shift 3

=SUMPRODUCT(--(CY7:DQ7=3),1-MOD(COLUMN(CY7:DQ7)-COLUMN(CY7),2),CY8:DQ8)

change the 3 to a 2 etc. for other shifts

There might be an easier way, what's in the intermediate cells, CZ7, CB7 etc?
Do you have headers, e.g. in CY1:DQ1, if so what's in those?

The above code would not work for me.
Here is a small example of what I am working with:

shift	total	shift	total	shift	total
1	40	3	1000	2	250

Why didn't that work, what result did you get, zero, error, something else?

If your headers, "shift" total etc. are in row 6 try this formula for shift 3

=SUMPRODUCT(--(CY6:DQ6="shift"),--(CY7:DQ7=3),CY8:DQ8)