how do a display a sum in Calc. ?

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

how do a display a sum in Calc. ?

ladylucky94803







Sent from Windows Mail
Reply | Threaded
Open this post in threaded view
|

Re: how do a display a sum in Calc. ?

Wade Smart-2
=sum(a1+b1)

Also sent to sender

On Tue, Oct 30, 2018, 12:23 <[hidden email]> wrote:

>
>
>
>
>
>
>
> Sent from Windows Mail
Reply | Threaded
Open this post in threaded view
|

Re: how do a display a sum in Calc. ?

Howard Blum
In reply to this post by ladylucky94803
If you properly insert the formula into the cell the sum should appear
automatically after you hit the enter button.

On Tue, Oct 30, 2018 at 10:23 AM <[hidden email]> wrote:

>
>
>
>
>
>
>
> Sent from Windows Mail



--
Howard Blum
Pro Mobile Notary
PO Box 834
Novato, CA 94948
415-898-4130
http://pro-mobile-notary.com
Reply | Threaded
Open this post in threaded view
|

Re: how do a display a sum in Calc?

Brian Barker-2
In reply to this post by Wade Smart-2
At 12:25 30/10/2018 -0500, Wade Smart wrote:
>=sum(a1+b1)

Since you chose to broadcast this to the masses, it is perhaps worth
saying that it is somewhat amusing overkill.
o Why not =SUM(A1)+SUM(B1) or =SUM(SUM(A1+B1))?
o Would you multiply using =PRODUCT(A1*B1) or =SUM(PRODUCT(A1*B1))?
(All of these work!)

=SUM(A1+B1) adds the two values together - using the "+" operator -
and then passes the result to the SUM() function to add it to - oh,
er, nothing else.

No: instead, only EITHER
=A1+B1
OR
=SUM(A1,B1)
makes sense.

Brian Barker  


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]