Hi all,
I have problem with sumproduct please help me, I'm really stuck..
My data is attached. I want to search coal ABC sum value based on the date on B5.
My attempt: =SUMPRODUCT(($L$4:$L$13),($K$4:$K$13="ABC")*(MONTH($M$4:$M$13=B3))*(YEAR($M$4:$M$13=B4)*($M$4:$M$13<>"")))---> failed.
Thanks in advance guys!
Bookmarks