Thanks so much! You have helped me so much! I appreciate your help!

Aggie

"Max" wrote:

Here's your earlier sample, with the formula implemented:
http://cjoint.com/?eAgTyEMBRC
Aggie_Carrot_Program_Report_2007.xls

Usually, when you copy n paste formulas direct from postings into formula
bars, you need to clean up the pasted formula before pressing ENTER. There
would be some line breaks introduced into the pasted formula. Just clean up
with the Delete key or Backspace key as necess.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Aggie G" wrote in message
...
Thanks for the formula. When I plugged in the formula, the cell displays a
REF error. What I did was press f2 and then hit enter and box appears for
me
to select the file from where the data is supposed to pull from. If I
reselect the same file I am working in, the correct number appears. For
whatever reason, the formula is not recgnoizing that the worksheet is
within
the same workbook. What should I do?