Phil, you are not wrong, sumifS() came out with 2007 (you could use a sumproduct() instead though), however....
m_789 I notice that the file you uploaded indicates 2007 or later (.xlsx), but your profile says 2003. Please update your profile as necessary, members tailor questions based on your excel version
Bookmarks