Thread: Max Value, Sum Product, Between Date Range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
p45cal[_16_] p45cal[_16_] is offline
external usenet poster
  
Posts: 1
Default Max Value, Sum Product, Between Date Range

=SUMPRODUCT(MAX((X2:X5000=A2)*(Y2:Y5000)*(Z2:Z5000 =B2)*(Z2:Z5000<=C2)))

assumes B2 contains start date, C2 contains end date.
You may want to adjust the '=' and '<=' to just '' and '<' depending
on whether you want the dates in B2 and C2 to be included or excluded
from the result.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121906

Reply With QuoteReply With Quote