How do I create a formula for an entire column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to create a formula that uses an IF function, and have it apply to an
entire column. I tried naming the column, and defining the formula, but
nothing happens.
 
What problem are you trying to solve?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
One example might be.........

=IF(SUM(A:A)>100,SUM(A:A),"")

More specific details would probably yeild something more fitting to your
need.

Vaya con Dios,
Chuck, CABGx3
 
Back
Top