Formula Question
 

I have this formula entered, yet I don't have all of the data in yet. Right
now I only have data for Row 11.
=IF(SUM(Data!C10:C12)-SUM(Data!AK10:AK12)=0,"",SUM(Data!T10:T12)/(SUM(Data!C10:C12)-SUM(Data!AK10:AK12)))
Here is what each thing equals: C10=0, c11=95105, c12=0, t10=0,
t11=219810.98, t12=0, ak10=0, ak11=103240.7, ak12=0. I want to hide the
formula but keep it in the sheet until all of the data is input. Can anyone
help me do this?
Thanks,
Kati

Formula Question
 

Hi,

Suppose you need ALL the data before you want the formula to display, here
is one way

IF(COUNTA(C10:C12,AK10:AK12,T10:T12)<9,"",IF(SUM(D ata!C10:C12)-SUM(Data!AK10:AK12)=0,"",SUM(Data!T10:T12)/(SUM(Data!C10:C12)-SUM(Data!AK10:AK12))))

If any of the necessary cells are empty, then the total cells containing
anything will be <9.

If this helps, please click the Yes button.

--
Thanks,
Shane Devenshire


"Kati" wrote:

I have this formula entered, yet I don't have all of the data in yet. Right
now I only have data for Row 11.
=IF(SUM(Data!C10:C12)-SUM(Data!AK10:AK12)=0,"",SUM(Data!T10:T12)/(SUM(Data!C10:C12)-SUM(Data!AK10:AK12)))
Here is what each thing equals: C10=0, c11=95105, c12=0, t10=0,
t11=219810.98, t12=0, ak10=0, ak11=103240.7, ak12=0. I want to hide the
formula but keep it in the sheet until all of the data is input. Can anyone
help me do this?
Thanks,
Kati