tags:

views:

5

answers:

0
Q: 

How can you use data entered in one cell to manipuate the number of cells added together in another?

I'm completely new to spreadsheets. I hope spreadsheets come under the remit of this site. If not my apologies.

Basically I'd like to enter the # of years in one cell, call it variable x. Then I'd like another cell(s) to add up the sum of only x number of cells. It seems pretty basic, but I have no idea how to go about it.

Thank you for any help.

related questions

Set cell format in google spreadsheet using python api
How do I return multiple columns of data using ImportXML in Google Spreadsheets?
Accessing Google Spreadsheets with C# using Google Data API fails with Mono
Php Form data to Google Spreadsheets
Import JSON data into Google Spreadsheet
How safe am I signing into Google Spreadsheets with yeroon.net/ggplot2
Can I access a (private) google spreadsheet by inserting a password in the URL ?
Insert hundreds of rows into Google spreadsheet with Zend Gdata?
How to display Google Online Spreadsheets in browser using Servlets
Google Spreadsheet multiple column filter using OR
Run Google apps script on Google-Spreadsheet event?
accessing variable sheet ranges within Google spreadsheet?
How can I convert Excel VBA to Google spreadsheets Javascript API?
What's the right tool for this job in Google Spreadsheets?
Making a simple searchable directory of people and their skills in a day - Which technologies?
How do I insert a row in to a Google spreadsheet using c#
using Zend_Gdata_Spreadsheets for public spreadsheets?
Google Doc Api: Spreadsheets with Charts
Google Spreadsheets API - updateCell via PUT or PHP?
How to save data in unpublic google spreadsheet using PHP without Zend Gdata library?
What is the function to return the name/address of a cell or range (Spreadsheet)?
How to use the Google SpreadSheets API to feed data to an application?
python + Spreadsheet
Google Docs Spreadsheet Automatic Coloring
What would be the spreadsheet function to sum all values in one column based on criteria from another column (I'm using google spreadsheet)