Forum Discussion
Number of active client cases.
Hello! I am making an excel-sheet for a welfare service. I register the date we received the referral in column A and the date for closing the client case in column C. I want to know how man...
Lorenzo That is correct! I solved that problem. But now I would like to know how I can count cells with a january date in column A that are on the same row as an spesific age category 16-18 in column E. Could you help me with that?
Could you post a picture showing your columns A through E please?
Thank you for your response! This is my sheet. I would like to know the number of cells with a january date in column A that are on the same row as a spesific age category in column F (ex. 18-20).
ā
in H2:
=COUNTIFS( A2:A101,">=" & DATE(2023,1,1), A2:A101,"<=" & DATE(2023,1,31), F2:F101, "18-20" )- Thanks again! I am having trouble putting this into my sheet and my company policy wont allow me to download your file. Could you show me how it looks in the insert function menu?