Thread: Matching and calculating 2 worksheets
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
mayanair[_3_] mayanair[_3_] is offline
external usenet poster
  
Posts: 1
Default Matching and calculating 2 worksheets

hi,

how do you make a formula like below to be dynamic?

=SUMPRODUCT(--(Sheet2!A$1:A$100=A1),--(Sheet2!B$1:B$100="Yes"))

Coz if were to increase the amount of data in the sheet then ill hav
to manually change the max cell limit.

Pls enlighten me on this

Thanks!! :

--
mayanai
-----------------------------------------------------------------------
mayanair's Profile: http://www.excelforum.com/member.php...fo&userid=3384
View this thread: http://www.excelforum.com/showthread.php?threadid=53626

Reply With QuoteReply With Quote