Forum Discussion
Counting overdue complaints based on days overdue
Hi Everyone, I'm setting up a complaints tracker and want to be able to highlight overdue complaints which are still listed as open. There is a target date for the complaint to be closed out a...
You can probably use the COUNTIFS function. See Excel COUNTIFS Function
If you want more specific help, please provide information about the setup of your worksheet, or attach a sample workbook.
HansVogelaar Thank you for your speedy reply. I think a Count IF function would be best, do you think I would still need to count the overdue dates separately.
I have attached a sample sheet for reference.
Does this do what you want? It's an array formula, you have to confirm it with Ctrl+Shift+Enter, otherwise it won't work as intended.
=COUNTIFS(A4:A33,">"&I4:I33,H4:H33,"Open")HansVogelaar Thank you very much for your help on this, I don't have much experience with Assay functions and this worked perfectly. I will save this in the future to use for other formulas.
ThanksJade