I believe your solution will double-count entries
if say column J2 = to and column N2 = B2.
Correct, Shane. Thanks.
It should have been:
=SUMPRODUCT((J2:J10="to")*((L2:L10=B2)+(N2:N10=B2) 0),AV2:AV10)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---