PDA

View Full Version : function



mortred
11-24-2009, 11:04 PM
pls help...

i have several data in a column and i wanted to place the sum in a specific cell , also the result must be subtracted from specific cell.

ex.
data sum data diffence
a1 b1 c1 d1 e1 f1 g1

20 10 20 5 55 100 45

Bob Phillips
11-25-2009, 01:37 AM
Try

=SUM(A1: D1) (without the space)

and

=F1-E1