P Peo Sjoblom Jun 1, 2004 #2 =SUMPRODUCT(--(DateRange>=DATE(2004,4,10)),--(DateRange<=DATE(2004,5,10)),Qt yRange) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom
=SUMPRODUCT(--(DateRange>=DATE(2004,4,10)),--(DateRange<=DATE(2004,5,10)),Qt yRange) -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom
R Ron Rosenfeld Jun 1, 2004 #3 in project I want to sum Work quantitees between 2 dates help please Click to expand... =SUMIF(DateRange, ">=" & StartDate, WorkQuantities) - SUMIF(DateRange, ">" & EndDate, WorkQuantities) --ron
in project I want to sum Work quantitees between 2 dates help please Click to expand... =SUMIF(DateRange, ">=" & StartDate, WorkQuantities) - SUMIF(DateRange, ">" & EndDate, WorkQuantities) --ron
