Hello,
I have been using excel for quite a bit of time but I am not able to fix this issue. Attached is the excel containing my example. Basically I have multiple products (A, B, C, D etc.) with monthly data on sale and stock. So what I wish to do is to be able to let say for example return the total sale of product A in the month of January.
Please help
Product Jan Feb
Sold stock Sold stock
A 10 5 4 2
B 3 3 6 7
Result needed
Jan
A sold
A stock