Hi Friends,
Please help me to short it out this issue.
Sales Date Product Amount
1/4/2014 Pen 500
1/1/2015 Pencil 1500
3/1/2015 Pencil 3000
I don't want to create pivot.
I want total sales of pencil in 2015. I tried SUMIFS function, but I couldn't find a solution.
Answer should be........
Pencil 2015 4500
Bookmarks