Can this formula be placed in CELL AT3 and insert the "x" into CELL B29?

[Joe Cramblit]

=IF(SUM(B$33:B$44)>0,"x","")

I need to have the "x" (or nothing) to appear in cell B29 based on th
SUM shown BUT I want to move the actual formula out of B29 so tha
clearing cell B29 will not have an effect on the working of th
formula. Cell B29 would be completely empty.

Sounds rather simple but I can't figure it out. Maybe it sounds simpl
because it's impossible.

Thanks

 

[Ron de Bruin]

You must use the Change event

Read Chip Pearson's site about Events
http://www.cpearson.com/excel/events.htm

Copy this in the worksheet module

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Application.Intersect(Range("B33:b44"), Target) Is Nothing Then
If Application.WorksheetFunction.Sum(Range("B33:b44")) > 0 Then
Range("B29").Value = "x"
Else
Range("B29").Value = ""
End If
End If
End Sub