Sum Data From two sheets

MKV

I am trying to sum data from two sheets, which I have figured out but I want an equation I can bring down the whole role.

=SUM([Month to Date Actual]@row, {Sheet - (01-January) Range 3})

I do not want to do this on every sheet, I want to that. like in excel I can us for the whole row.

Help please

Dale Murphy

@MKV Do you mean row or column? Do you want to make the formula a Column Formula?

Is that what you are after? Not sure that formula works as a column formula ...

dm

MKV

@Dale Murphy That did not work, I tried that earlier, it only pulls in the data form the main sheet correctly, it does not pull in the second figure from the data sheet, it just stays with the first row number on second data set.

Otherwise that would have worked