Forum Discussion
Number of active client cases.
Hi jorgen1990
I want to know how many active cases we have. To do this I would need to count how many cells in column A that have a date, and how many cells in column C have a date
This isn't really clear, to me at least. By 'active cases' do you mean those that have an Open Date (column A) and no Close Date (column C)?
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" )