how to clear cell based on text in other column

's Computer Specifications

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

's Computer Specifications

Pls post in ONE group ONLY.
See ans in your other post
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Summing a column based on the length of text in a cell in anothercolumn	nughty@gmail.com	Microsoft Excel Worksheet Functions	13	26th Nov 2008 05:42 PM
clear cell based on text in opposing column	bubba@homie.net	Microsoft Excel Worksheet Functions	0	13th Jul 2008 11:37 PM
specify a specific column to input text based on another cell's content	jsd219	Microsoft Excel Programming	14	27th Oct 2006 11:04 PM
Re: Formatting Cell Based on Text in Column Beside It - Round 2	Frank Kabel	Microsoft Excel Programming	0	18th Mar 2004 02:55 PM
Deleting Rows based on text in cell & formatting cell based on text in column beside it	=?Utf-8?B?U3RldmU=?=	Microsoft Excel Programming	4	26th Feb 2004 03:31 PM