Accounting Value Doesn't Do AutoSum

[T3as3r22]

Hi,
I have some value in column E, and I am trying to do AutoSum. But instead of column sum, it is showing me as the image attached.
I have already tried this,

• Formulas/Calculation Options/Automatic
• Formulas/Calculation Options/Manual

No result, still have the same issue as shown in the image attached.
I am using a home license version of Office 2021. OS - Windows 11, 64-bit system.

Any solution?

 

[Jimmypop]

Hi there

If you want to Autosum column E then your formula should go at the bottom of the last empty cell in Column E... in your case looks like E11... You are getting this due to the fact that there are also numbers to the left side of the Column (in A1 to D1). Or just change your cell references accordingly.... maybe somethin similar to below...

Book1
	A	B	C	D	E	F
1	10	28	3	0
2	17	1,061	5	6	$ 599.00	$ 38.44
3	20	60	9	1	$ -	$ -
4	31	340	2	0	$ 69.99	$ 7.35
5	10	13	1	1	$ 107.57	$ 11.30
6	8	15	3	2	$ 239.97	$ 25.08
7	10	26	4	3	$ 699.00	$ 44.04
8	10	19	0	1	$ 29.99	$ 3.15
9	12	27	7	1	$ 407.00	$ 37.44
10	15	46	5	3	$ 197.80	$ 23.10
11	29	58	10	4	$ 197.80	$ 23.10
12					$ 2 548.12
Sheet1

Cell Formulas
Range	Formula
E12	E12	=SUM(E2:E11)

 

[T3as3r22]

I just tried this. A reference image is attached.

 

[Jimmypop]

Did you set your calculations back to automatic? What happens when you press F9? Are all your numbers formatted as numbers and where you want Accounting format is it formatted as such?

• Formulas/Calculation Options/Automatic

 

[T3as3r22]

Yes, calculations is set to automatic. A screenshot is attached when F9 pressed. Format is set to accounting.

 

[RoryA]

It looks like your data is text. Use Find/Replace on that column to replace the $ signs with nothing

 

[Jimmypop]

On your image it only says =SUM()... it should have the range reference e.g. =SUM(E1:E11)... see below example from my test sheet...

Book2.xlsx
	A	B	C	D	E	F
1	10	28	3	0	$ -
2	17	1,061	5	6	$1 813.00	$ 38.44
3	20	60	9	1	$ 599.00	$ -
4	31	340	2	0	$ -	$ 7.35
5	10	13	1	1	$ 69.99	$ 11.30
6	8	15	3	2	$ 107.57	$ 25.08
7	10	26	4	3	$ 239.97	$ 44.04
8	10	19	0	1	$ 699.00	$ 3.15
9	12	27	7	1	$ 29.99	$ 37.44
10	15	46	5	3	$ 407.00	$ 23.10
11	29	58	10	4	$ 197.80	$ 23.10
12					$4 163.32
Sheet1

Cell Formulas
Range	Formula
E12	E12	=SUM(E1:E11)

 

[T3as3r22]

On your image it only says =SUM()... it should have the range reference e.g. =SUM(E1:E11)... see below example from my test sheet...

Book2.xlsx
	A	B	C	D	E	F
1	10	28	3	0	$ -
2	17	1,061	5	6	$1 813.00	$ 38.44
3	20	60	9	1	$ 599.00	$ -
4	31	340	2	0	$ -	$ 7.35
5	10	13	1	1	$ 69.99	$ 11.30
6	8	15	3	2	$ 107.57	$ 25.08
7	10	26	4	3	$ 239.97	$ 44.04
8	10	19	0	1	$ 699.00	$ 3.15
9	12	27	7	1	$ 29.99	$ 37.44
10	15	46	5	3	$ 407.00	$ 23.10
11	29	58	10	4	$ 197.80	$ 23.10
12					$4 163.32
Sheet1

Cell Formulas
Range	Formula
E12	E12	=SUM(E1:E11)

It is solved. It was text. I removed $ value and changed those value to accounting and it solved. Thanks