Jul 16 2019 05:02 AM
Hi. I need help creating a formula and using the drag tool. See the attached example.
I have created the simple formula, but I dont know how to format the reference cells to use the drag tool. O the attached xls file follows my doubt. Please, what I should do? You can format the xls as an example and send back to me?
Regards,
Alexandre
Jul 16 2019 05:11 AM
Hi
Are the 2 formulas in cells O2 & O3 correct (from your work perspective).
Are you just wondering because of the Gree error indicator/
or your calculation should pick up a different input?
I will help you accordingly
Nabil Mourad
Jul 16 2019 05:14 AM
Jul 16 2019 05:25 AM
@nabilmourad . Thank you.
No, o cell O3 I need this formula: =SOMA(D2:D3)/N3, and dragging to O4, the formula needs to be =SOMA(D4:D5)/N4. But I dont know how to set the correct selection of the intervals automatcally when drag to O5, that shoud be =soma(d5:d6)/n5. Is it possible? Do you understand my necessity?
Forgive my english....
Regards, Alexandre.
Jul 16 2019 05:31 AM
Hi Alexandre
Copying Formulas requires a Pattern. I do not see any consistent pattern in your formula.
Nabil Mourad
Jul 16 2019 08:13 AM
Hi
Select cells A2:G2 and INsert > Shift cells down, so that your first row of data is on line 3.
Then use the formula in cell O3 of
=(INDEX(D:D,(ROW()-1)*2)+INDEX(D:D,(ROW()-1)*2-1))/N3
and copy down