| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If column = value sum another column and place result in cell
I think this would be a simpler solution:
=SUMPRODUCT(--('SOURCE DATA'!D2:D4000="133957")+('SOURCE DATA'! D2:D4000="146268"),'SOURCE DATA'!G2:G4000) however I'm not getting my total of column G based on the two values sepecified in range D2:D4000 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add numbers in a column and transfer result to another column | Excel Worksheet Functions | |||
| Lock column/row in place | Excel Discussion (Misc queries) | |||
| how to display the column or cell the MIN() result came from? | Excel Worksheet Functions | |||
| read a column of names and place a number in the next cell | Excel Discussion (Misc queries) | |||
| How do I convert the result of LARGE to the cell (or column) refe. | Excel Worksheet Functions | |||
Threaded Mode
