Drag formula to sum multiple row data horizontally

[rrmando]

Hello party people. I need help figuring out how to drag the formula below horizontally across columns so they reference the vertical data below. I tried using the transpose function but no luck. Will this require the index function? I can't get it to work. Thank you for your help.

cell A1 would be ='Job Data'!M47+'Job Data'!M101+'Job Data'!M185
cell B1 would be ='Job Data'!M48+'Job Data'!M102+'Job Data'!M186
cell C1 would be ='Job Data'!M49+'Job Data'!M103+'Job Data'!M187
etc., etc.

 

[joshman108]

Try this

=INDIRECT("'Job Data'!M"&COLUMN(AU1))+INDIRECT("'Job Data'!M"&COLUMN(CW1))+INDIRECT("'Job Data'!M"&COLUMN(GC1))

 

[Joe4]

You can also use the OFFSET function, i.e. place this is cell A1 and copy to the other columns in that row:

=OFFSET('Job Data'!$M$47,COLUMN()-1,0)+OFFSET('Job Data'!$M$185,COLUMN()-1,0)

 

[rrmando]

Thank you gentlemen. Much appreciated.

 

[Joe4]

You are welcome. Glad we could help.