LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Help with a formula (Multiple lines to sum and return if)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trouble with Array multiple return formula Kate Excel Discussion (Misc queries) 4 September 29th 09 04:38 PM
In Excel 2007 chart with multiple lines, mouse doesn't track lines sfuelling Charts and Charting in Excel 1 August 19th 09 09:41 PM
formula to add multiple lines with multiple meanings chubbybat Excel Discussion (Misc queries) 1 March 3rd 08 10:28 AM
Is there any way to use HLOOKUP in an array formula to return multiple matches? [email protected] Excel Worksheet Functions 9 August 31st 06 03:55 AM
Formula to return cell contents based on multiple conditions Bill Excel Worksheet Functions 3 January 19th 05 09:59 AM


All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"