Sum multiple columns with random blanks

[O177812]

I am sure this is simple but I am having a brain fart.
I have 4 columns of data (numbers) and there are random cells that are blank
My formula (A1+B1)-C1 returns "#value" if any of the columns are blank.

How can I fix this without writing some long if/then statement?

Plant Inventory	October
Incoming	Forecast	Available
97,150	#VALUE!
440,000	182,700	163,878	458,822
610,450	75,150	#VALUE!
6,057,614	2,375,100	1,476,357	6,956,357
136,350	#VALUE!

 

[DanteAmor]

My formula (A1+B1)-C1

In none of the cells in your image do you seem to have the formula (A1+B1)-C1.

The error occurs when you have blank spaces, which is different from an empty cell. Or because you have texts in the cells.

If so:

varios 10oct2024.xlsm
	A	B	C	D
1	a	b	c	0
2	4	b	c	4
3	a	2	c	2
4	a	b	3	-3
5	4	2	c	6
6	4	b	3	1
7	a	2	3	-1
8	4	2	3	3
9	4	2	-3	9
Hoja3

Cell Formulas
Range	Formula
D1:D9	D1	=SUM(A1:B1)-MAX(MIN(C1,0),C1)

 

[Alex Blakenburg]

Using Dante's example this should also work.

=SUM(A1:B1)-N(C1)

The long form would be:

=N(A1)+N(B1)-N(C1)

You obviously have If statements that are returning "". A better option might be to change them to returning 0 and if you want to not see zeroes format the cell to not show zero.

 

[Phuoc]

Or try this:

=SUM(A1:B1)-SUM(C1)