hi
i am trying to apply this below formula, but doesn't work well.
=SUMPRODUCT(('Sold List'!$L$7:$L$3000=D5)*('Sold List'!$K$7:$K$3000))
this error is coming out - #VALUE!
i want bring from Sold List value into Account List and D5 is in Account List
hope could be understand.
thanks in advance