Spreadsheet: 63986d1264826310-vlookup-and-sum-sumproduct-monday-thru-friday-sheets-mldover89-sdg11
Sheet: Summary

Weekly Summary
Public Que
8am-12pm
 | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
12pm-5pm
 | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Inbound Que
8am-12pm
 | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
12pm-5pm
 | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
Agent | Calls Answered | Calls Placed | Total Calls - All | Time on Calls Inbound | Time on Calls Outbound | Time on Calls - All | Avg. Call Inbound | Avg. Call Outbound | Avg. Call - All
[NAME] |  |  |  |  |  |  |  |  |  |  | Today, 06:42 PM
[NAME] |  |  |  |  |  |  |  |  |  |  | mldover89 |  | Sumproduct - Monday thru Friday sheets - mldover89 - SDG11.xlsx
[NAME] |  |  |  |  |  |  |  |  |  |  | Registered User   Join Date: 29 Jan 2010
[NAME] |  |  |  |  |  |  |  |  |  |  | Location: College Station, Texas
[NAME] |  |  |  |  |  |  |  |  |  |  | MS Office Version:Excel 2008
[NAME] |  |  |  |  |  |  |  |  |  |  | Posts: 2
[NAME] |  |  |  |  |  |  |  |  |  |  | VLOOKUP and SUM
[NAME] |  |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/716061-vlookup-and-sum.html
Chase Schuchard |  |  |  |  |  |  |  |  |  |  | I'm trying to do a VLOOKUP equation that adds the results it finds from 5 different worksheets.
[NAME] |  |  |  |  |  |  |  |  |  |  | It's to find a person's last name, then add the number of calls answered from each time their name is found.
[NAME] |  |  |  |  |  |  |  |  |  |  | I have this so far, and am not sure if any of it is correct.
[NAME] |  |  |  |  |  |  |  |  |  |  | '=SUM(VLOOKUP("Monday!Hunnicutt, Tuesday!Hunnicutt, Wednesday!Hunnicutt, Thursday!Hunnicutt, Friday!Hunnicutt","Monday!$A$4:$C$60, Tuesday!$A$4:$C$60, [NAME], [NAME], Friday!$A$4:$C$60",3))
[NAME] |  |  |  |  |  |  |  |  |  |  | The name of the sheets is the day of the week (Monday, Tuesday, etc)
[NAME] |  |  |  |  |  |  |  |  |  |  | It's searching for the last name ([NAME])
[NAME] |  |  |  |  |  |  |  |  |  |  | The information is in A4:[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | And the numbers it needs to add are in column 3.
[NAME] |  |  |  |  |  |  |  |  |  |  | Any help would be greatly appreciated!
[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  | '=SUMPRODUCT(--(Monday!$A$4:$A$60=RIGHT($A23,LEN($A23)-FIND(" ",$A23,1))),Monday!$C$4:$C$60)+SUMPRODUCT(--(Tuesday!$A$4:$A$60=RIGHT($A23,LEN($A23)-FIND(" ",$A23,1))),Tuesday!$C$4:$C$60)+SUMPRODUCT(--(Wednesday!$A$4:$A$60=RIGHT($A23,LEN($A23)-FIND(" ",$A23,1))),Wednesday!$C$4:$C$60)+SUMPRODUCT(--(Thursday!$A$4:$A$60=RIGHT($A23,LEN($A23)-FIND(" ",$A23,1))),Thursday!$C$4:$C$60)+SUMPRODUCT(--(Friday!$A$4:$A$60=RIGHT($A23,LEN($A23)-FIND(" ",$[NAME])
[NAME] |  |  |  |  |  |  |  |  |  |  | '=RIGHT($A23,LEN($A23)-FIND(" ",$A23,1))
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Kasi Prachyl
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Makenzie Dover
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]