I'm trying to merge formulas but one is a Countifs function and the other is a Sumproduct.
The following Sumproduct formula returns a count of rows in which the date in D is greater than the date in P, providing there is a date in each D and P.
I also use the following Countifs to return a count of rows with "Initial*" in E and no value in P. (There are formulas in P but it does not always return a date value)Please Login or Register to view this content.
Now, I'd need this last formula to also count rows with "Initial*" in E with a date value in D that is greater than the date in P...Please Login or Register to view this content.
This formula gives me a values error:
And this formula returns a 0:Please Login or Register to view this content.
Can anyone spot where I'm going astray?Please Login or Register to view this content.
Bookmarks