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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Index Match
See reply to your other post.
Biff "Gingit" wrote in message ... 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, |
Reply |
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 |