I wish to have a formula that is a conditional (Sumif) addition on columns in a table. The formula as I wrote it is:
=Sumif(Table6[[#all],[Period]],"<=" & $N$8, Table6[[#All],[ Labor - Eng ]])
The problem is that when I copy this formula to the next cell to the right, I wish to have the [Period] portion stay referencing [Period] on the next calculation but the 3rd parameter of the formula the [ Labor -Eng ] should adjust and reference the next relative column. How can I make the copy do this without having to manually edit the cells each time?
=Sumif(Table6[[#all],[Period]],"<=" & $N$8, Table6[[#All],[ Labor - Eng ]])
The problem is that when I copy this formula to the next cell to the right, I wish to have the [Period] portion stay referencing [Period] on the next calculation but the 3rd parameter of the formula the [ Labor -Eng ] should adjust and reference the next relative column. How can I make the copy do this without having to manually edit the cells each time?
