Thread: Find two values in worksheet to return one value
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG
 
Posts: n/a
Default Find two values in worksheet to return one value

Correna,


=SUMPRODUCT((DensityChart!A1:A5000=B3)*(DensityCha rt!B1:B5000=B4)*(DensityChart!D1:D5000))

As you change your values in B3 and B4, the formula will automatically
look for those new values.

If this is the same question I answered on your other "unanswered"
post, you had indicated the solution worked.


Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=539006

Reply With QuoteReply With Quote