=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

--
Message posted from http://www.ExcelForum.com

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Joe Cramblit " wrote in message ...
=IF(SUM(B$33:B$44)0,"x","")

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

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

Thanks!


---
Message posted from http://www.ExcelForum.com/