| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
sum product in an index possibly?
trying to do a formula along the lines of: search column b for "n", if its an
"n" then multilply column d by column c. I need it to include all occurances though. so in the exapmle below it would include eeee, hhhh, and kkkk. does anyone know what a proper formula would be? many thanks. A b c d eeee n 60 1 ffff y 55 2 gggg j 12 1 hhhh n 50 2 iiii j 14 3 jjjj y 14 1 kkkk n 50 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i turn the help index on again? | Excel Discussion (Misc queries) | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
| If statement needed | Excel Worksheet Functions | |||
| index match and sum | Excel Worksheet Functions | |||
| index to a range of cells | Excel Worksheet Functions | |||
Threaded Mode
