View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wouter HM Wouter HM is offline
external usenet poster
 
Posts: 99
Default If specific cell is not empty, copy (or enter) formulas andformat

Hi Stacie,

What yo u coulf try is making your formulas a bit clever, if you did
not do so.
Let us say you have in your A column a formula

=myFormula(E2,G2,H2)

Ic cound be

=IF(ISEMPTY(E2),"";myFormula(E2,G2,H2))

A COUNT on column A will not include those rows whithout a value in
the E column, since the COUNT formula only includes numeric values.


HTH,

Woute