H
hforman
Thanks, Lance. The formula works great except for one hitch (which
neglected to mention in my original post). I'm putting together a blan
form that we can give to our clients. I have 10 rows set up fo
executive officers, but most companies will only have a few, so ther
will be blank lines. The formula is giving the $10,400 result t
adjacent cells that are blank, which is screwing up my total. Is ther
any way to add a "If Null = 0" statement?
the Max/Min formula did not work for me. It gave the $52,000 result t
everything.
Thank you, Heathe
neglected to mention in my original post). I'm putting together a blan
form that we can give to our clients. I have 10 rows set up fo
executive officers, but most companies will only have a few, so ther
will be blank lines. The formula is giving the $10,400 result t
adjacent cells that are blank, which is screwing up my total. Is ther
any way to add a "If Null = 0" statement?
the Max/Min formula did not work for me. It gave the $52,000 result t
everything.
Thank you, Heathe