Thread: sum the values of a range based upon multiple ranges and criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SteveG SteveG is offline
external usenet poster
  
Posts: 1
Default sum the values of a range based upon multiple ranges and criteria

LiveIt,

=SUMPRODUCT((A2:A57="A")*(B2:B57="M")*(D2:D57))

HTH

Steve


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

Reply With QuoteReply With Quote