Question about Computers & Internet

# I do not know how to average or sum data on the PsiPlot program,which I thought was similar to Excel. All that I want to do is to be able to add data in column2 through column6 to give me the computed answer in column7. I have a large data volume (>125,000 data points per column) and so I would like to be able to drag this formula to the entire column in one (like you can in Excel). I tried typing the following in Column7 and had no success: =Column2+Column3+Column4+Column5+Column6 No matter if I leave a space after the = sign or or in between the columns it does not compute. Can anyone help me with this? I do not have a manual. -Rob

Posted by on

• rapowoski May 01, 2010

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?

×

• Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

• Master

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

• Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

• Master

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

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

## 1 Suggested Answer

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

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### How program to compute the average for any number students ?

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

### Ms Access 2003

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

### What are the formulas in grading the grades uisng microsoft excel

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.

1. All formulas begin with an equals sign (=).
2. 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.
3. 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.
4. 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.
5. 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

### When you select some data in excel , you can come to know the count , sum , average , range ,min ,max .The same appears below scroll bar . It has suddently disappeared from my workbook .Hence very...

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.

Feb 24, 2011 | Microsoft Excel for PC

### What is the function of Microsoft excel?

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

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

### Count , sum ect below scroll bar disappeared

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

Jan 17, 2009 | Microsoft Excel for PC

### Excel formula

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

### Excel and the AVERAGE function

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.

Dec 30, 2007 | Computers & Internet

### Budgets in excel

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.

Excel 2007 had a budget format workbook

New workbook, Select Budgets in the last hand navigation, Select Personal Budget.

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

## Open Questions:

#### Related Topics:

34 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert