Search : in
By :

Excel Equation

Last answer on Dec 30, 2008 3:39:22 pm GMT sarahdara, on Dec 29, 2008 8:44:50 pm GMT 
 Report this message to moderators

Hello,
I am working on Excel spreadsheet and need help with the add formula in a specfic row. Does anyone know how to write it?


Example:
1
1
1
2
2
2
3
3
3

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « Excel Equation » in :
If condition in excel Show
Excel "IF" formula problem Show
Spreadsheets - Conditional expressions Show What is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
How to convert Excel into PDF? ShowHow to convert Excel into PDF? Here is a small tips about how to convert your excel files into PDF for your presentation. Step 1 PDF995 is software that gets installed on your computer which enables you to print any sources of document to...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download Excel Viewer Show
Download Excel Password Recovery Master Show
Download XLS (Excel) to DBF Converter ShowDescription The application is designed by WhiteTown Software. XLS (Excel) to DBF Converter is a tool that enables you to convert your XLS files to DBF format quickly and easily. Simple and easy to use, the application has been awarded from various...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

 mslizny, on Dec 30, 2008 3:39:22 pm GMT

Sara,

I see a vertical list of numbers. If these numbers are in a row, with each in an Excel cell going across, you can click in the blank cell at the end of the list of numbers and type "=Sum" and Excell will create a formula that puts the range of the cell addresses in that last cell.

You can get the same effect by clicking to place your cursor in the next blank cell and clicking on the Sigma button on the toolbar (looks like a back-wards Z". This button, "AutoSum" will enter the =Sum formula with the range of cells for you.

   
Reply to mslizny
Ask your question Reply
They need your help