|I am working on a worksheet and I need to calculate the total cost of the boxes the employees have sold from each product. |
On my ProductSales sheet, each item has its own column and each employee the same.
(Ex. Item1 is on D3, Item2 is on D4, Item3 is on D5 etc)
(Ex. Employee1 is on A3, Emp2 is on A4 etc)
On the ProductData sheet now, there is a list the same way as on ProductSales that includes the number of boxes each employee has sold but there is also another Column with the Products that also includes the Price of each one.
(Ex. Item1 is on A2 and his price on E2, Item2 is on A3 and his price on E3)
I am using a formula on the ProductSales sheet but I cant make it increase the row number when I drag it to the right.
The formula I am using is:
Now when I drag it to the right to autofill the cells it doesn't change anything.
I want to make that that way, that each time I drag it to the right it will make the row number in
ProductData!$E3 increase by 1.
Ex. From =ProductData!$K2*ProductData!$E3 when its dragged in the cell to the right, become =ProductData!$K2*ProductData!$E4
Is there a way?