| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
summing multiple rows with like references
I have imported data from a database into Excel. An example:
AWGM USD 10000 AWGM USD 50000 BGM USD 5000 These are in columns and rows. I would like to sum values in the third colum for AWGM USD, which would be 60000. I cannot find a function to lookup like values in column 1(AWGM) and return the summed value of the respective data from column 3 (60000). Any help? Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert a data from multiple rows into 1 column? | Excel Worksheet Functions | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
| Inserting Multiple Rows with Formulas | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
