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 |
#2
|
|||
|
|||
Matt
SubTotal ? Or use an Advanced Filter to extract unique values and then use SUMIF. Or maybe a Pivot Table ? Regards Trevor "cardinalred" wrote in message ... 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 |
#3
|
|||
|
|||
Try this.
With datalist A1 to C100 Enter Colimn A criteria in D1 Enter Column B criteria in D2 =SUMPRODUCT((A1:A100=D1)*(B1:B100=D2)*C1:C100) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "cardinalred" wrote in message ... 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 |
Reply |
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 |