Jump to content



Photo
- - - - -

Fx-9860Gii How To Get Sum Total For Numbers In Spreadsheet Column?

spreadsheet

  • Please log in to reply
1 reply to this topic

#1 HuckleberryCatfish

HuckleberryCatfish

    Newbie

  • Members
  • Pip
  • 5 posts

  • Calculators:
    fx-115ES, fx-9860GII

Posted 01 March 2013 - 05:34 AM

I have made a spreadsheet with 10 rows and 5 columns. I need to add up the numbers in order to get a total at the bottom of each column. (adding the numbers vertically) I read the spreadsheet chapter in the user manual. But I can't find any instructions for a way to make the calculator give a total for the numbers in a column. Please help! Thanks.

Edited by HuckleberryCatfish, 01 March 2013 - 05:37 AM.


#2 flyingfisch

flyingfisch

    Casio Maniac

  • Deputy
  • PipPipPipPipPipPipPipPip
  • 1891 posts
  • Gender:Male
  • Location:OH,USA
  • Interests:Aviation, Skiing, Programming, Mountain Biking.

  • Calculators:
    fx-9860GII
    fx-CG10 PRIZM

Posted 01 March 2013 - 01:40 PM

If you have a column from say A1 to A4 and you want the sum in A5, then move the cursor to A5 and type any number, then press delete and press <span class=F5' />,<span class=F5' /> and then type A1:A4 and press <span class=EXE' />.

It will put the sum in that cell.





Also tagged with one or more of these keywords: spreadsheet

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users