I've built a model that uses the SUMIFS function rather frequently, and we have some people opening the model in Excel 2007 that receive an error (#NAME I believe).
What is causing this problem, and what can be done to fix it? If they're using 2003, I tell them that's the problem, but I'm not sure what to tell someone in Excel 2007 or guide them how to fix it.
Thanks!
Bookmarks