Hi everyone. This is a difficult one (for me at least).
I have a spreadsheet for the office. Rows depicting stock items, columns depicting vehicles stock is taken for. With totals at the end of each column and totals at the end of each row.
What i'm looking for is the correct formula/ or formulae that allows the following.
If somebody takes a quantity of 2 (for example.degreaser tins) and places them onto vehicle 1, i want to just place the number 2 in that relevant box, the total for that vehicle column will show 2. But at the same time, the total at the end of that row will display the total cost of the items taken. Is it possible to have a value hidden within the relevant rows which calculate for each quantity entered?
I've Attached the empty sheet for you to see what i mean
Bookmarks