Hi,
I have a data input as per the attached. I need a formula to count if the dates in column C are within the first week of Jan, then check column D if there is a loan keyed in, then check if the days in column E has exceeded 11 days. The result in the example if one because there 1 that matches all 3 criteria. Please assist. Thank you. I tried using the following formula but it did not work:
=COUNTIFS(C3:C8,">="&G3,C3:C8,"<="&G8,D3:D8,"<>"&"")+COUNTIFS(E3:E8,">=11")
I have a cross post here:
https://www.mrexcel.com/forum/excel-...ate-range.html
Bookmarks