Formula Question


K

Kati

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
 
Ad

Advertisements

S

ShaneDevenshire

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(Data!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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top