Thanks for the help - that worked perfectly. I knew SUMIFS wouldn't work in Excel 2003, just couldn't get any of the other formulas I knew that would work to deliver the exact sum I wanted. I appreciate the help.
I'm trying to adjust an Excel 2007 workbook so that all of my formulas work with Excel 2003 and I've got one table has me stymied. I've tried a number of SUMPRODUCT and SUM calculations but keep getting a value of "$0" returned. Here's my formula:
=SUMIFS('Data Tab'!S$6:S$3770,'Data...