Thread: SUMPRODUCT
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mik mik is offline
external usenet poster
 
Posts: 8
Default SUMPRODUCT

HI,

Can someone help me please?
Cell "L21" needs a total of following;
If code "BC" is found in range "B14:B391", find value from "H14:H391" and
then multply with a percentage rate in "A1"

Thank you.