Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup using 2 sheets
Hey Guys,
Thanks in advance for the help. I have a 2 sheet document. Sheet 1 "Report" Column D: Outgoing calls Sheet 2 "PhoneData" Column B: Name of caller (e.g. Smith, Rex, Sam) I need to calculate the total number of calls made by "Smith" so i need a formula for Sheet 1 column D row 3 ("Smith") to calculate how many times the name "Smith" appears in Sheet 2 Column B. Then: I need a formula for Sheet 1 column F row 3 ("Smith") to calculate how many calls where over 00:60 for "Smith", Data from Sheet 2 Column I. Many thanks to all that help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup across several sheets | Excel Worksheet Functions | |||
VLOOKUP Between Sheets | Excel Worksheet Functions | |||
vlookup in several sheets | Excel Worksheet Functions | |||
Vlookup from 2 different sheets | Excel Worksheet Functions | |||
Vlookup with 8 sheets-please help! | Excel Programming |