I do use excel 07. I cant seem to follow how that formula was able to work however in using the ""

How would I simply this? Thank you so much for the help. I have been spending the last week trying to make it work.