LadyHawk wrote...
No it didn't work because the cells that have the price cost aren't next to
each other.
($I$4:BY4). They are specifc cells:
- August is in column X;
- September is in column AG;
- October is in column AP;
- November is in column AY;
- December is in column BH;
- January is in column BQ;
- February is in column BZ.
....

Then make them into an array.

X4*{1,0,0,0,0,0,0}+AG4*{0,1,0,0,0,0,0,0,}+AP4*{0,0 ,1,0,0,0,0}+AY4*{0,0,0,1,0,0,0}
+BH4*{0,0,0,0,1,0,0}+BQ4*{0,0,0,0,0,1,0}+BZ4*{0,0, 0,0,0,0,1}

Or, since these appear to be every 9th column, use something like

INDEX($P$4:$BZ$4,9*<some.expression.that.increment s.by.1)