| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index Match
I have a spreadsheet with the following car sales:
Dept A Dept A Dept A Dept B Dept B Dept B Jan Feb Mar Jan Feb Mar Audi 550 230 650 85 320 300 Chev 350 260 780 800 250 254 Buick 420 312 240 87 99 187 How do I use match and sum the sales for each car and each departments using the months? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Index, Match and filters | Excel Discussion (Misc queries) | |||
| Match Index | Excel Worksheet Functions | |||
| Match or Index Question | Excel Worksheet Functions | |||
| Match & Index | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
