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

One way is to use array functions - assuming that this data is in the
top left of your worksheets then try

=SUM(IF('2nd Worksheet'!$A$1:$A$5=A1,1,0)*IF('2nd
Worksheet'!$B$1:$B$5="Completed",1,0))

Then remember to press Ctrl-Shift-Enter and you're done.


--
Superdude
------------------------------------------------------------------------
Superdude's Profile: http://www.excelforum.com/member.php...o&userid=33850
View this thread: http://www.excelforum.com/showthread...hreadid=536261

Reply With QuoteReply With Quote