MS EXCEL (Math: Product / Addition)

Fafhrd said:

If you select cells E4 and F4, and then continue the selection down , for say 100 rows, with <Shift>+<down arrow> keys, then enter <Ctrl>+D to copy down, then the formulae in both E4 and F4 should be copied down in those 100 rows. You only seem to have copied down in the column E. You can check whether there are formulae in a cell by clicking it and checking what is in the cell edit box.

Or just mark the last cell with good formula click and hold on cross mark (lower right corner of cell) and drag down... Formula will be copied in all cells



result:



Edit: and you don't need to have zero (0) in that empty row. There is the same formula in F column... (empty cell is zero)