I am using the conditional sum under the tools tab in Exel Xp, I am trying to count several different choices in 4 columns, each time I use it a pop up appears with "End Bug" and Help. It is working some of the time for some selections. Please help or help me with a formula that counts Age Gender Race Risk.

I don't think you can do it! Could you check your numbers.

If we are using the numbers 1-9 once and only once in a 3x3 magic square, the sum of the rows + the sum of the columns should be 90, since 1+2+3+4+5+6+7+8+9 in the rows adds up to 45 and 1+2+3+4+5+6+7+8+9 in the columns adds up to 45.

When trying to solve, the magic number seem to be the sums 24 and 10. To get 24, the only three numbers that add to 24 are 7 + 8 +9. Similarly to get 10, the lowest numbers re 1 and 2 and the smallest big number to use is 7. I then ran out of number trying to get 21, 13 and 15 sums.

Good luck,

Paul

Conditional formating should be able to this. But how is your data organized? (Column headers, Row headers etc.)

The post addresses several questions

1. 1-Var statistics and standard variations
2. 2-Var stats (calculating the statistical values)
3. Regressions (linear or otherwise)
   

I assume you know the theory. I will show you the key strokes for 1-Var statistics and 2-Var statistics
Press [MODE][3:STAT] [1:1-VAR]. You are ready to enter values in the X column.
Enter a number and press [=]. Cursor jumps to second number to enter.
Keep entering numbers and pressing [=] till all numbers are in. Press the [=] key after the last one.
Press [AC] key to clear the screen.
Press [SHIFT] [STAT] (above digit 1.) then [5:Var]. Screen displays the statistical variables 1:n ;2: x bar; 3: x sigma n; 4:x sigma n-1.
Press the number corresponding to Referable you want, ex 1:n . The variable appears on screen. Press [=] and it will be displayed.
To display another variable press [SHIFT][STAT][5:Var][ 1,2, 3, or 4] .

- To access the sum of squares sigma x^2 and the sum of data sigma x press[SHIFT][STAT][4:SUM] then [1: for sigma x^2] or [2: for sigma x]. Press [SHIFT][STAT][6:MinMax] to access minX and maxX.

To perform 2 variable statistics you press [MODE][3:STAT] and any of the other regression options (except 1:1-Var). A two column template opens where you enter the X and Y values. When finished entering data, press [SHIFT][STAT][5:Var]. to access the different statistics. As I assumed above, you should be able to recognize what each variable means.

REGRESSIONS

To use the regression a+bx,
1. Select STAT mode : [MODE][3:STat] [ENTER][2:a+bx]
2. Fill the X and Y values in the template.
3. Press [SHIFT][STAT][7:Reg]
You have several options 1:A to get coefficient A, 2: B to get coefficient B, 3:r etc.

To access each one, you have to press [SHIFT][STAT][7:Reg] anew.

To access the various sums, you press [SHIFT]{STAT][4:Sum] and you can select Signa_x, Sigma_x^2, etc..

Hello,
Set the [Mode] to [3:STAT]. You are offered the choices
1:1-Var
2:A+BX
3:__+cX^2
etc.
If you want to do 1-Var statistics, you press 1:1-Var. A column template opens where you put the X values. If a value is repeated you enter it several times. (there is no frequency column.)
When you enter all data you press [SHIFT][STAT]

You have several choices among them
4: SUM to get SigmaX^2 and Sigma X
5: VAR to get n, the mean X bar, the sample and population standard deviations
6:MINIMAX to get MinX and MaxX
7: Distr the Distributions.

If you want to perform 2-Var statistics
You press [MODE][STAT] and select one of the Regression models
2:A+BX
3:__+cX^2
etc.
The selection of any of the 7 regression models, opens a two-column template where you enter the X and Y values
When finished press [SHIFT][STAT]
The choices offered are

1. Type takes you back to select type of statistics to perform
   
2. Data To edit the data in the columns
   
3. Edit To insert or delete a value
   
4. SUM To access the calculated values of SigX^2,SigX,SigY^2,SigY,SigXY,SigX^3, SigX^2Y, SigX^4
   
5. Var : To access the calculated values n, Xbar, Sample STD for x, S STD for Y, Pop STD for X, and Pop STD for Y
   
6. MinMax : MinX, MinY, MaxX, MaxY
   
7. Reg: Gives you the regression coefficients for the particular regression model you want to test.

The mean is represented by X bar.
The variance is the SQUARE of the Standard Deviation.
Hope it helps.

simply follow this tutorial

http://www.osix.net/modules/article/?id=53

You have to use an If statement for the same. Use multiple conditions in If statement like this.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=242

See the part where it explains the AND

Use the function =sum() to add numbers. To sum, for example, all of column A, enter in the formula bar =sum($A:$A). You can use the subtotal function within the range you are adding and the answer will not count towards the final total.

Copy and paste into a new worksheet seemed to solve problem

Use Pivot table, it might help you reach your target..!!

at first select the 1st page data and select data-subtotal from the upper menu list.
then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

If not solved pls get me that data as to reference.

thanks