Question about Computers & Internet

Ad

I've never seen or used this program and neither it's available on net. So I'd suggest you to hit F1 key and search for formulas that is the best I can suggest you.

Posted on May 01, 2010

Ad

Hi,

You will write as the letter (B1) not as "column1".

Please find the answer below:

To sum it:

=B1+C1+D1+E1+F1

or

=SUM(B1:F1)

To get average value type in the 7 th column:

=AVERAGE(B1:F1)

Hope this helps.

Posted on Apr 30, 2010

Ad

Hi there,

Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

The easiest way is to add a field, name it attendance or something and assign a value of one. Then sum column a / sum column b for average.

Feb 18, 2015 | Microsoft Excel for PC

If Access is anything like Excel, you can put in one of the cells:
=SUM(A1:A5)
If I remember rightly. That will add all the values from A1 to A5 together and display it. Alternatively, you can do =SUM( and then select all the values you wish to add together with your mouse by dragging, or selecting individually by holding CTRL whilst individually selecting.
Hope this helps, because I'm only going under the assumption that Access is similar to Excel. Either way, you will need to use a formula similar to the one I just showed you.

Sep 10, 2007 | Microsoft Office Standard for PC

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

I don't have 2010, but I do have 2007. Now, provided that status bar is still there, right click on it and check the boxes you want to show on your status bar, such as sum, count, etc.

If you status bar is not there, make sure your are in NORMAL view and not Full Screen View. Hit the escape key a few times to get back to Normal. It would also be a good idea to click on the View ribbon menu to see what view you are in.

After that, I am at a loss to assist you.

If you status bar is not there, make sure your are in NORMAL view and not Full Screen View. Hit the escape key a few times to get back to Normal. It would also be a good idea to click on the View ribbon menu to see what view you are in.

After that, I am at a loss to assist you.

Feb 24, 2011 | Microsoft Excel for PC

Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

Excel 2007 - This is called the status bar, right click on it if it is blank and put click to put a click next to the options you require.

Previous Versions - Click View --> Status Bar

Previous Versions - Click View --> Status Bar

Jan 17, 2009 | Microsoft Excel for PC

CHOSE THE PERTICULAR CELL WHERE THE SUM IS GOING TO BE DISPLAYED AND HYPERLINK IT IT WITH SHEET 2

Apr 12, 2008 | Microsoft Excel for PC

Here is one way:

In this example, my numbers are in cells a1 through a4. My average is computed with the formula:

=SUM(A1:A4)/COUNTIF(A1:A4,"<>0")

I'm summing the range of numbers and dividing that by the count of nonzero numbers. With this formula, you'll get an error if there are no nonzero numbers.

In this example, my numbers are in cells a1 through a4. My average is computed with the formula:

=SUM(A1:A4)/COUNTIF(A1:A4,"<>0")

I'm summing the range of numbers and dividing that by the count of nonzero numbers. With this formula, you'll get an error if there are no nonzero numbers.

Dec 30, 2007 | Computers & Internet

Dear Madiha35,

I would recommend the use of the Table Function in Excel.

Here are the steps in Excel 2007, if this does not work for your version please add comment for me to reply to.

Conversely, If you would like the softcopy of the screenshots, I would be happy to email them to you.

Step 1: Enter your data into the worksheet.

Step 2: Create Table

Highlight the relevant data

On the insert tab, click on Table

Step 3: Verify Table range is correct, Click OK

Step 4: Select the cell you where you wish to Sum Data.

Click on Autosum.

Step 5: To Insert new data

Click on the sum row in the table, (Not the entire worksheet row)

Right click, Insert, Insert Table rows from above

Step 6: Enter new data in row

Step 7: Data is automatically calculated in formula.

Oct 22, 2007 | Computers & Internet

34 people viewed this question

Usually answered in minutes!

I am using a program caled PsiPlot. That is how Microsoft Excel works. However, Each column in PsiPlot is labeled as column1 column2 column3...] The identity of each cell is labeled as C1:1 for column1:row1, C2:2 for column2:row2 etc. It tried your way (the Excel way) on PsiPlot and it still seems to not work. Any further ideas?

×