 Highlighted

# FORMULA HELP

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

5 Replies
Highlighted

# Re: FORMULA HELP

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?

Highlighted

# Re: FORMULA HELP

is this what you want?

Highlighted

# Re: FORMULA HELP

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.

# Re: FORMULA HELP

Hi Alexandre

Copying Formulas requires a Pattern. I do not see any consistent pattern in your formula.

Highlighted

# Re: FORMULA HELP

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