OMIGOSH ... You are an Angel ...!!!!

It doesn't say quite what you are saying ... but when I clicked on Flavor,
it showed the "refers to" as only going to row 1000 ... Now all I hafta do is
go and change all those to maybe 2000 or so ...

Thank you so very much ...!!!!

All my best ... CJ :)~

"Ron Rosenfeld" wrote:

OK, my guess is that your formula is calculating correctly, but your data is
not what you think it is.

1. From the top menu bar, select Insert/Name/Define. You should see "Flavor"
and "TheoryGals" in the list. Click on each of them in turn and tell me what
it says in the "Refers To:" Box.

2. Then check and see if you have any "OctML" entries in the defined range for
"Flavor".

3. If OctML is a text entry in a cell, the "=" is superfluous and should be
eliminated. If OctML is a Defined Name, then the syntax should be "="&OctML.

------------------------------------