View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jordan Smith
 
Posts: n/a
Default Answer's a little more complicated than regular formulas, but what do I need to do?

Thanks John.

I don't really want the circular references because I want to make it
possible to change the numbers. Seperating out the input from output
looks like what I will have to do. (I wasn't aware of the counta
function which will help also.

Thanks again.

Michael: I know that my example may raise eyebrows. I am working on a
more complicated spreadsheet and used this example to get an answer to
the problem without bogging everyone down in understanding my "final"
goal ;) Thanks for your answer though. I'm going to try and use what
you guys have given me tomorrow. It's just about 3am here, haha.