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.

	A	B	C
17	Needed	120	120
18	Active	100
19
20
21
22
23
24	total short	20

<tbody>
</tbody>

 

[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.