Solved Adding totals from multiple ws according to employee name

Microsoft Office 2010 professional
January 6, 2014 at 13:15:11
Specs: Windows 7
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!

See More: Adding totals from multiple ws according to employee name

Report •

January 6, 2014 at 13:18:50
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.


Report •

January 6, 2014 at 13:48:12
✔ Best Answer
Try the technique offered here. I just tried it and it seems to work.

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


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

Report •

January 9, 2014 at 07:25:59
Thank you for your help, both of you. DerbyDad's SumProduct was what I needed!

Report •

Related Solutions

Ask Question