If you've already answered a similar question for me, I apologize but I cannot figure this out. I have a workbook that has 13 pages, Jan, Feb, Mar, Apr, etc. and a final one called Totals.

Column A has employee names but each month is different, names are added or subtracted. Some employees might be on a couple months, others are on each of the 12. If the employee is there, I need to grab the number in column B off each page and put it in column B on the totals page.

Maybe I'm overthinking this I was trying to SUM countifs, then tried IFs with +, and looked into vlookup.

Bet someoen is going to read this and immediately know what to do. Help!

If the Name is in A and you want the figure that is in B

then it would seem a =VLOOKUP() of some type would be

what your looking for.MIKE

Try the technique offered here. I just tried it and it seems to work. http://www.mrexcel.com/forum/excel-...

My version SUMS "Bob" across Sheet1, Sheet2 and Sheet3, with the sheet names stored in H1:H3.

=SUMPRODUCT(SUMIF(INDIRECT("'"&H1:H3&"'!A:A"),"Bob",INDIRECT("'"&H1:H3&"'!B:B")))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Thank you for your help, both of you. DerbyDad's SumProduct was what I needed!

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History