 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / June 2007Sum numbers based on specified criteria
If I have a spreadsheet with various data in a column (perhaps sales rep names) and I want to sum all values associated with that sales rep, how do I do it. For example, if I have hundreds of clients assigned to either sales rep A, B, C, D or E and I want to know the dollar value of sales for each sales rep, what is the proper formula? I would separate totals for the sales dollars where sales rep = A, sales rep = B, on so on. Have a look in the help index for COUNTIF & SUMIF  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > If I have a spreadsheet with various data in a column (perhaps sales rep > names) and I want to sum all values associated with that sales rep, how do [quoted text clipped - 6 lines] > what is the proper formula? I would separate totals for the sales dollars > where sales rep = A, sales rep = B, on so on. The proper formula would probably be either: Sumit Sum (probably an array sum) Sumproduct Dsum or maybe a Pivot Table or SubTotals Check the Help file on each and see which best meets your needs. Good luck. Ken On Jun 18, 4:23 pm, R.Miller <RMil...@discussions.microsoft.com> wrote: > If I have a spreadsheet with various data in a column (perhaps sales rep > names) and I want to sum all values associated with that sales rep, how do I [quoted text clipped - 4 lines] > what is the proper formula? I would separate totals for the sales dollars > where sales rep = A, sales rep = B, on so on. > names) and I want to sum all values associated with that sales rep, how do > I [quoted text clipped - 5 lines] > what is the proper formula? I would separate totals for the sales dollars > where sales rep = A, sales rep = B, on so on. Assuming for example purposes that your sales rep names are in column A and the sales figure is in column B... =SUMPRODUCT((A1:A13="A")*(B1:B13)) where you would replace the A in quote marks with the sales rep's name or ID text (and, of course, expand the range to suit your data) Rick =SUMPRODUCT(--($A$2:$A$100)="Sales rep A"),$B$2:$B$100) B = Sales values Put sales rep in cells (say C2 to C10) and use: =SUMPRODUCT(--($A$2:$A$100)=C2),$B$2:$B$100) and copy down OR look at SUMIF function HTH > If I have a spreadsheet with various data in a column (perhaps sales rep > names) and I want to sum all values associated with that sales rep, how do I [quoted text clipped - 4 lines] > what is the proper formula? I would separate totals for the sales dollars > where sales rep = A, sales rep = B, on so on. hi =sumif() you would need a sumif formula for each sales rep. assuming sales are in column A and the rep names are in column b..... =sumif(B1:B5000,"RepName", A1:A50000) you can stack the sumif formulas in a summary column then total the summary column for a grand total. regards FSt1 > If I have a spreadsheet with various data in a column (perhaps sales rep > names) and I want to sum all values associated with that sales rep, how do I [quoted text clipped - 4 lines] > what is the proper formula? I would separate totals for the sales dollars > where sales rep = A, sales rep = B, on so on. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.