The following formula returns 59:Formula:
=SUMPRODUCT((List!H5:H64<=List!I5:I64)*(List!H5:H64< List!D2))
Let us know if you have any questions.
The following formula returns 59:Formula:
=SUMPRODUCT((List!H5:H64<=List!I5:I64)*(List!H5:H64< List!D2))
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks