Formula Question

  • Thread starter Thread starter Kati
  • Start date Start date
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
 
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

Similar Threads

I need to copy a formula to a 100 cells 3
How do I say… 11
SUM / COUNT formula 3
PMT formula help 5
Follow-Up (Clarification) to MIN question 4
#REF! errors 1
How to indicate in formula to choose the entire column starting from a specified cell? 3
sumproduct and even numbered rows 6

Back
Top