Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
Thank you in advance for the help. One sheet one I would like to return the sum of data from sheet two if the salesperson name matches. Here are the details: Sheet 1 In column A I have the names of sales people (listed by row) - header is "Name" In column B I have cells available to total the sales people numbers by month Sheet 2 In column A, the sales people are listed many times In column B, lists the Account name (not important for this help) In column C, is the total sold to that customer Now in the B column, I would like to match the name of the salesperson and sum all of their dollars sold in column C. I hope I did not make a train wreck of this explanation. Thanks Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trouble with Array multiple return formula | Excel Discussion (Misc queries) | |||
In Excel 2007 chart with multiple lines, mouse doesn't track lines | Charts and Charting in Excel | |||
formula to add multiple lines with multiple meanings | Excel Discussion (Misc queries) | |||
Is there any way to use HLOOKUP in an array formula to return multiple matches? | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions |