Thank you Marcia!!! Your suggestion worked perfectly! I didn't even use IFS, I just inserted your formula, which was also more concise than what I had written. I really struggled with this so I am VERY appreciative of your feedback.



Microsoft Excel Forum - you rock...!!!



Jonathan