adding and subtracting


Posted by John on January 24, 2002 2:58 PM

I want to know how to add all columns going down.
With a total on the bottom.

I also need to know how to subtract each row going across.

I also realize this is a very simple request. It seems
I don't operate in the simple world. But to me this is beyond me. The wizard in excell does not seem to deal in simple math, and the online sites just don't understand. Any help will be greatly appreciated. Thanks in advanced. :}

Posted by john on January 24, 2002 3:26 PM




Posted by Paul on January 24, 2002 4:55 PM

=Sum(A1:A50) for columns, =(A1:H1) for rows, adjust numbers as needed