one formula for worksheet

E

emmy

when working in a worksheet is it possible to only plug in the formul
once for a selected area, but still recognize that the formul
pertains to each individual row ?

for example

A2+ B2= sum
A3+ B3 = sum
A4 + B4= sum


THANK YOU !!!!!!!

emm
 
A

Ardus Petus

In C2, enter =A2+B2
Select C2
Drag down (or copy down)

cell C3 will show =A3+B3

HTH
 
Top