SUM only if cell has text

[Tazzbjs]

Ok, I've done it before and now I can remember how I did it. I need to only return a value in row 24 if there is a number in row 18. If there is a number in row 18 the value in row 24 is Row 17-Row 18. Heres a quick example of the table.

[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]Needed[/TD]
[TD]120[/TD]
[TD]120[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]Active[/TD]
[TD]100[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]total short[/TD]
[TD]20[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi,

Like this?

Book1
	A	B	C	D
16
17	Needed	120	120	140
18	Active	100		50
19
20
21
22
23
24	total short	20		90
Sheet5

Cell Formulas
Range	Formula
B24	=IF(B18<>"",B17-B18,"")

B24 formula copied across.