Forum Discussion
Function EDATE in SUMPRODUCT
Hello, I want to have a SUMPRODUCT function with several matrice, and one of them is comparing 2 dates but i wanna add 1 month to one of them: =SUMPRODUCT(Range;([Actual end date range]<EDATE([P...
Not really, as I'm trying to compare 2 dates while in your example I only see 1 date ?
Also I've attached an example excel sheet so it's easier to understand what I'm looking for
Also I've attached an example excel sheet so it's easier to understand what I'm looking for
=SUMPRODUCT(('Raw Data'!$B$2:$B$116="Closed")*('Raw Data'!$G$2:$G$116="Critic")*('Raw Data'!$D$2:$D$116<'Raw Data'!$I$2:$I$116))I'd insert an additional column in sheet "Raw Data" for the EDATE, in the attached file it's column I. Then the above formula returns the intended result. Column A in sheet "Raw Data" isn't required since SUMPRODUCT counts the number of occurrences.