How to return a value usin multi variable criteria

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

16example.xlsx (9.46 Ko)

A bit complex because the layout of the data is not what we usualy expect. For example, do not merge cells ...

Let me know if this is undestrandable for you.

20example.xlsx (10.32 Ko)
Rechercher des sujets similaires à "return value usin multi variable criteria"