| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum a column if two criteria are met
I need a formula that sums column C for each "Loc" by "Item"?
A B C LOC Item WA Txn Value 1241 R3331 595.20 1241 R3334 595.20 1241 R3334 1,488.00 1242 R1400 908.46 1242 R1400 908.46 1242 R3334 1,488.00 1242 R3334 1,190.40 1243 R1400 908.46 1243 R3334 297.60 -- swestberry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up Data by Row criteria and column criteria | Excel Worksheet Functions | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| Based on Mulipple Criteria acrossed Column count last column | Excel Worksheet Functions | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Threaded Mode
