These formulas were working fine yesterday and today, no go. I was receiving some correct values, but as soon as I deleted the rows above to make the dummy worksheet, the same wrong data value error appeared for those cells, too. I don't know why they are tied to above cells, which were completely unrelated. The cell values are all formatted as "General." Please help. I have to present the worksheet that I created on Monday and it has decided to go haywire. Thanks in advance. ~Sandy

Book 1 Example.xlsx