You're welcome! Thanks for reporting how you fixed the problem.

Ferg wrote:
Debra,
Thank you. I don't know what the old lap top had, but the current one
had a blank for the list separator. I changed this to comma, and
everything seems to work OK. All the old SUMIFs automatically now have
commas and the new ones work perfectly.
Again, thank you.
Ferg.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html