On Tuesday, February 18, 2014 7:29:03 AM UTC-8, Claus Busch wrote:
Hi Howard,



Am Tue, 18 Feb 2014 07:20:10 -0800 (PST) schrieb L. Howard:



It is returning a #Value error with the green triangle. Plus a pop up window "Update values: Sheet 1".



have a look:

https://skydrive.live.com/#cid=9378A...121822A3%21326

for workbook "CountIf"





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

The usual suspect to cause the error in this case was ME. Misspelled sheet name.

That trim formula could very well come in handy.

Thanks again.

Howard