| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If column = value sum another column and place result in cell
Are you looking for numbers or text strings??? If you are looking for numbers
then... =SUMPRODUCT(--('SOURCE DATA'!D2:D4000=133957), 'SOURCE DATA'!G2:G4000)+ SUMPRODUCT(--('SOURCE DATA'!D2:D4000=1462268), (--('SOURCE DATA'!D2:D4000<=1462270), 'SOURCE DATA'!G2:G4000) Don't worry about the or stuff. Just use 2 sumproducts... -- HTH... Jim Thomlinson "S Himmelrich" wrote: thank you for the suggestion, I've done as you mentioned: =SUMPRODUCT(('SOURCE DATA'!D2:D4000=133957)+('SOURCE DATA'! D2:D4000=146268),'SOURCE DATA'!G2:G4000) however the result is zero, there are values 0 in the G2:G4000 range to add |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Place Date in One column when entry is made in another column. | Excel Worksheet Functions | |||
| If column = value sum another column and place result in cell | Excel Discussion (Misc queries) | |||
| Calculating column 'J' and offsetting result in column 'L' on nextblank row (continue to end of sheet) | Excel Programming | |||
| Get current cell value and place formula based on it in another column | Excel Programming | |||
| read a column of names and place a number in the next cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
