Thread: sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] fi.or.jp.de@gmail.com is offline
external usenet poster
  
Posts: 51
Default sumproduct
Hi,

I have formula =SUMPRODUCT(--(B3=Sheet2!A:A),--(D3=Sheet2!B:B))

how should use same formula in using VBA like
appllication.worksheetfunction.sumproduct......

Reply With QuoteReply With Quote