LinkBack URL
About LinkBacksMaybe something like this:
=SUMPRODUCT((MONTH(B1:D1)=12)*(A2:A11=E3),B2:D11)
where E3 is the product to lookup, B1:D1 in the ship day row, A2:A11 is the product list and B2:D11 is your range with number of product shipped.
HTH
JG
Maybe something like this:
=SUMPRODUCT((MONTH(B1:D1)=12)*(A2:A11=E3),B2:D11)
where E3 is the product to lookup, B1:D1 in the ship day row, A2:A11 is the product list and B2:D11 is your range with number of product shipped.
HTH
JG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks