Need to Calculate only part of a formula in Excel 2003
 

I have a Microsoft Excel Users Manuel that says the following on calculating
part of a formula. (This is apparently Version 4 so the info is out of date.)

1. Select the cell containing the formula or type the formula in the formula
bar.
2. In the formula bar, select the portion of the formula you want to
calculate.
3. Press F9
4. Click the enter box or press ENTER

My cell has this formula:
=SUM(B5,B7,B9,B11,B13,B15,B17,B19,B21,B23,B25,B27)

Right now I only want it to calculate =SUM(B5,B7,B9,B11) but I need to keep
the rest of the formula. i can get it to calculate correctly but it won't put
it in a useable format for the cell and I get an error. So basically it gets
to step 3 but won't let me enter the value. Do I need to make any other
setting changes?

Need to Calculate only part of a formula in Excel 2003
 

Your problem is that you don't have =sum(b5,b7,b9,b11) in your formula (you are
missing the closing bracket), so Excel can't evaluate it.

If you change your formula to:

=SUM(B5,B7,B9,B11,B13)+SUM(B15,B17,B19,B21,B23,B25 ,B27)

Excel will do the partial valuation for you.

--
Regards,
Fred


"Gabe" wrote in message
...
I have a Microsoft Excel Users Manuel that says the following on calculating
part of a formula. (This is apparently Version 4 so the info is out of date.)

1. Select the cell containing the formula or type the formula in the formula
bar.
2. In the formula bar, select the portion of the formula you want to
calculate.
3. Press F9
4. Click the enter box or press ENTER

My cell has this formula:
=SUM(B5,B7,B9,B11,B13,B15,B17,B19,B21,B23,B25,B27)

Right now I only want it to calculate =SUM(B5,B7,B9,B11) but I need to keep
the rest of the formula. i can get it to calculate correctly but it won't put
it in a useable format for the cell and I get an error. So basically it gets
to step 3 but won't let me enter the value. Do I need to make any other
setting changes?

Need to Calculate only part of a formula in Excel 2003
 

I believe that the process you describe is only a way of evaluating part of a
formula, you can't actually make excel ignore part of a formula like that.

Why don't you need to sum the remaining cells in this case, and when would
you want to sum them? There may be another approach that will work for you

"Gabe" wrote:

I have a Microsoft Excel Users Manuel that says the following on calculating
part of a formula. (This is apparently Version 4 so the info is out of date.)

1. Select the cell containing the formula or type the formula in the formula
bar.
2. In the formula bar, select the portion of the formula you want to
calculate.
3. Press F9
4. Click the enter box or press ENTER

My cell has this formula:
=SUM(B5,B7,B9,B11,B13,B15,B17,B19,B21,B23,B25,B27)

Right now I only want it to calculate =SUM(B5,B7,B9,B11) but I need to keep
the rest of the formula. i can get it to calculate correctly but it won't put
it in a useable format for the cell and I get an error. So basically it gets
to step 3 but won't let me enter the value. Do I need to make any other
setting changes?