FORMULA HELP

Copper Contributor

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

@ASOUZA 

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

 

@ASOUZA 

is this what you want?

Nabil Mourad

@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.

 

@nabilmourad 

Hi Alexandre

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

Nabil Mourad

@ASOUZA 

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