Thanks so much! I tried the formula but it is still not working. Is there maybe a better way write the formula?
To give you an understanding of what i am trying to do - I have a list of 25 different stores and each store has 150 items in it - each of the items having its own unique stock...
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...