Thank you, it worked, and I will be able to sleep at night...
I do have one more question. How do I get the value in the B3,B4,B5 to equal 0 if I have not entered a food in A2? It is screwing up other formulae that I have set up. Right now, I entered "blank" into my food list, and put the numbers at 0,0,0 which has solved the problem, but I am sure there is a better way. Thank you very much for your help.
Bookmarks