Right click sheet tabview codeinsert this. Now if you type in the word
payments into col g col v will CLEAR
Is that what you want?

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Columns("g")) Is Nothing Then Exit Sub
If UCase(Target) = "PAYMENTS" Then Cells(Target.row, "v").ClearContents
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
I am attempting to clear a cell in column V based on the text of the
same row in column G.
With actual numbers, I can do SUMIF(G9:G123,"5",V9:V123) - but I want
to actually clear the respective cell in V if "payments" is in column
G, and leave it alone if blank or other text exists. How can I do
that?

DLR