Hi all, pls help me with the following.. in this excel I attached I need to return the count of some details if it matches with a data in another cell.
for example,
if row D=possession then in row K I will need to get the count of 11-07-16. In this case answer is 1. But my formula is indicating 5.
This is what I wrote, =IF(D2:D20="Possession", COUNTIF(A2:A20,"11-07-16"),0)
Also what formula should I write if I would like to check for both Possession and Shifted together and return the value of 11-07-16 in row K?
Bookmarks