Index Match problem

Below is my formula (a single formula, I posted like this, so it's easier to read).

Anyhow, this formula is on several lines and I'm trying to add up data on each time a person does a certain task. The formula is working across all sheets, FEB thru DEC, but JAN is adding the first two lines correctly, and the rest is wrong. It doesn't make sense, because I cut and pasted the same data on all sheets to test the formula. Any ideas?

=INDEX(Jan!AG3:Jan!AG15,MATCH(A2,Jan!A3:Jan!A15))+
INDEX(Feb!AG3:Feb!AG15,MATCH(A2,Feb!A3:Feb!A15))+
INDEX(Mar!AG3:Mar!AG15,MATCH(A2,Mar!A3:Mar!A15))+
INDEX(Apr!AG3:Apr!AG15,MATCH(A2,Apr!A3:Apr!A15))+
INDEX(May!AG3:May!AG15,MATCH(A2,May!A3:May!A15))+
INDEX(Jun!AG3:Jun!AG15,MATCH(A2,Jun!A3:Jun!A15))+
INDEX(Jul!AG3:Jul!AG15,MATCH(A2,Jul!A3:Jul!A15))+
INDEX(Aug!AG3:Aug!AG15,MATCH(A2,Aug!A3:Aug!A15))+
INDEX(Sep!AG3:Sep!AG15,MATCH(A2,Sep!A3:Sep!A15))+
INDEX(Oct!AG3:Oct!AG15,MATCH(A2,Oct!A3:Oct!A15))+
INDEX(Nov!AG3:Nov!AG15,MATCH(A2,Nov!A3:Nov!A15))+
INDEX(Dec!AG3:Dec!AG15,MATCH(A2,Dec!A3:Dec!A15))

Originally Posted by FDibbins

If you create a list of all sheets, and give that list a range name (say - sheetnames), you could use something like this...
'=SUMPRODUCT(SUMIF(INDIRECT("'"&sheetnames&"'!A3:A15"),A2,INDIRECT("'"&sheetnames&"'!AG3:AG15")))

If that doesnt work for you, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I realized part of my problem was I forgot the dollar signs.

Anyhow, I got most of it working, and greatly simplified the sheet by having the total page show month by month.

But, two of the names are not adding correctly. The lines for Singleton show 4 (should be 2) and Forman show 1 (should be 4) and my overall total shows 14, but should be 15.

I attached the sheet. Thank you for your help.

Any ideas?

Originally Posted by bebo021999

Try INDIRECT to refer to month title in row 1 automatically:
In B2:

Please Login or Register  to view this content.

Drag down and accross.

I've never used the INDIRECT function, but it worked perfect.

Thanks!