Way to keep accounting/currency format column blank?

[charlesstricklin]

I have a kind of odd question. I have a column where if the two column's cells are blank, if I format the column as accounting any cells that meet that criteria appear as '$ -', and if I format the column as currency they appear as '$0.00'. Is there a way to keep the cell blank if both of the two cells added together are also blank/unused?

 

[Peter_SSs]

Like this?

24 03 23.xlsm
	A	B	C
1	$ 3.00	$ 2.00	$ 5.00
2
3	$ 6.00		$ 6.00
4		$ 7.00	$ 7.00
5	$ 5.00	$ 5.00	$ 10.00
Blank

Cell Formulas
Range	Formula
C1:C5	C1	=IF(COUNT(A1:B1),SUM(A1:B1),"")

 

[charlesstricklin]

Like this?

24 03 23.xlsm
	A	B	C
1	$ 3.00	$ 2.00	$ 5.00
2
3	$ 6.00		$ 6.00
4		$ 7.00	$ 7.00
5	$ 5.00	$ 5.00	$ 10.00
Blank

Cell Formulas
Range	Formula
C1:C5	C1	=IF(COUNT(A1:B1),SUM(A1:B1),"")

I've tried that and it fails to sum up the cells although it does blank the cell out either way. I've also tried =IF(COUNTBLANK(J2:L2)=0,"",SUM(J2:L2)) which sums up the cells properly but leaves $0.00 as the alternative.

 

[Peter_SSs]

What about you post a small sample with XL2BB then so we can test with the same data you have?

 

[charlesstricklin]

What about you post a small sample with XL2BB then so we can test with the same data you have?

Current Rideshare Income.xlsx
	I	J	K	L	M
1	Miles	Uber	Lyft	GRHB	Income
2	149	$ 49.49	$ 27.24		$76.73
3	51	$ 14.95			$14.95
4	106	$ 58.95			$58.95
5	157	$ 112.53			$112.53
6	41	$ 37.33			$37.33
7	164	$ 112.29			$112.29
8	130	$ 75.69			$75.69
9	124		$ 44.53		$44.53
10	110	$ 114.73			$114.73
11					$0.00
12					$0.00
13					$0.00
Rideshare

Cell Formulas
Range	Formula
I2:I13	I2	=IF(COUNTBLANK(G2:H2)=2,"",H2-G2)
M2:M13	M2	=IF(COUNTBLANK(J2:L2)=0,"",SUM(J2:L2))

That's cool! I didn't know how to do that.

 

[Peter_SSs]

Thanks for the XL2BB sample data.
Adapting the post #2 formula to the new ranges works for me as I understand the question.
Isn't this what you want as results? If not, which results are incorrect and what should they be?
All four columns are formatted as Accounting.

24 03 25.xlsm
	J	K	L	M
1	Uber	Lyft	GRHB	Income
2	$ 49.49	$ 27.24		$ 76.73
3	$ 14.95			$ 14.95
4	$ 58.95			$ 58.95
5	$ 112.53			$ 112.53
6	$ 37.33			$ 37.33
7	$ 112.29			$ 112.29
8	$ 75.69			$ 75.69
9		$ 44.53		$ 44.53
10	$ 114.73			$ 114.73
11
12
13
Rideshare

Cell Formulas
Range	Formula
M2:M13	M2	=IF(COUNT(J2:L2),SUM(J2:L2),"")

 

[charlesstricklin]

Thanks for the XL2BB sample data.
Adapting the post #2 formula to the new ranges works for me as I understand the question.
Isn't this what you want as results? If not, which results are incorrect and what should they be?
All four columns are formatted as Accounting.

24 03 25.xlsm
	J	K	L	M
1	Uber	Lyft	GRHB	Income
2	$ 49.49	$ 27.24		$ 76.73
3	$ 14.95			$ 14.95
4	$ 58.95			$ 58.95
5	$ 112.53			$ 112.53
6	$ 37.33			$ 37.33
7	$ 112.29			$ 112.29
8	$ 75.69			$ 75.69
9		$ 44.53		$ 44.53
10	$ 114.73			$ 114.73
11
12
13
Rideshare

Cell Formulas
Range	Formula
M2:M13	M2	=IF(COUNT(J2:L2),SUM(J2:L2),"")

That is perfect! I'm not sure what I was misunderstanding now.

 

[Peter_SSs]

Good news. Thanks for the conformation.