Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup
I have a sales spreadsheet that is broken down by month (in columns). Each
sale is listed individually (rows), so a salesperson may be listed several times. I would like to key in a month somewhere on the spreadsheet and have a formula that will check the month column headings, find the month indicated, and add up the sales for that month, broken down be each salesperson. Thanks in advance for your help! |
#2
|
|||
|
|||
Hi, Ellen
One easy way would be to sort your spreadsheet - month, salesperson. Then go to Data, Subtotal and select Salesperson when it asks for each change, SUM, Amount That will get you started. Carole O "Ellen" wrote: I have a sales spreadsheet that is broken down by month (in columns). Each sale is listed individually (rows), so a salesperson may be listed several times. I would like to key in a month somewhere on the spreadsheet and have a formula that will check the month column headings, find the month indicated, and add up the sales for that month, broken down be each salesperson. Thanks in advance for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Lookup Lookup | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |