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?
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?