Please look at this above, I wanted the column G to give the multiplication reference of column D3 to D20 and column F3 to F20 and I have applied the formula but excel 2013 didn't respond to that, I used handle to pull down the cell that has the formula from cell G3 to G20 it resulted to 0 but when I click on each cell I see that the normal formula that supposed to give the multiplication result of the implicated cells is not lost, please click on one of the cells from G3 to G19 and see what I mean
Secondly each time I add a value in C Column (Quantity by ml), I expected it to update automatically in a Column H (Total plus) and I have already created the formula, please click on H3 to see the example of the formula, the automatic update only take place on the Row in yellow color below, please kindly help me out I have passed 3 days and nights looking for a solution but unable to find any, is coursing me a sleepless night, I would be glad if anyone can kindly help me out.
Ink sells record.xlsxInk sells record.xlsx
Bookmarks