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.
|