Excel Sum Formula

[mfaisalrazzak]

I want to sum two value but result shows add with + Sign. Example

Student ID Fee Student ID Sum

1 100 1 400 (calculate sum but when goes to cell show like +100+300)
2 200 2 700 (+200+200+300)
1 300 3
3 200 4
4 100
2 200
2 300

[mfaisalrazzak]

I want to sum two value but result shows add with + Sign. Example

Student ID Fee Student ID Sum

1 100 1 400 (calculate sum but when goes to cell show like +100+300)
2 200 2 700 (+200+200+300)
1 300 3
3 200 4
4 100
2 200
2 300

[patel]

it's not clear for me, attach a sample file with more comments

[Admin]

Hi

You can toggle the formula view by cliking Ctrl + `

[getlucky]

In MS excel 2007, you can go to select the Home button and select Excel Options>> Go to Advanced, under "Display options for this worksheet" u can select "Show Formulas in cells instead of their calculated results. This would show you the formula instead of the value.

[Excel Fox]

Do you mean you want to show the result of the sum in the cell, but the formula in the cell should not contain an equal (=) sign at the beginning?

[mfaisalrazzak]

Attched Sample File