Put this in P2:

=IF(SUM(C2:O2)=0,"delete","")

and copy this down. Then you can apply autofilter to column P and
select the word "delete" from the filter pull-down. Highlight all the
visible rows, then click on Edit | Delete Row. Then select "All" from
the filter pull-down to see what remains.

Hope this helps.

Pete

On Mar 14, 9:10*pm, Caligirl
wrote:
how do I write such a formula?



"Pete_UK" wrote:
You can't actually delete a row using a formula, so you would either
have to do it manually (with a formula indicating to you the row(s)
which need deleting), or with a macro.

Hope this helps.

Pete

On Mar 14, 6:56 pm, Caligirl
wrote:
Okay, I got it. *I just had to add this to your formula (f2-j2)/i2. *That
made it work. *Thank you so very much. *Now I can move on to the next
dilemna. *

Here's one for you: *If cells c thru o are equal to zero then delete the
row? *How in the world would I write that?

"Caligirl" wrote:
I am fairly new to writing formulas. *The formula I always use is F2-J2/I2. *
Pretty simple, except when I2 has no data or is zero then I get the #DIV.. *
How do I either keep the #DIV from showing or write the formula in such a way
that it basically says: *If I2 is less than, equal to or has no data then
leave blank, if not process the above formula.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -