Forum Discussion

JadeHughes93's avatar
JadeHughes93
Copper Contributor
Dec 16, 2020

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...
BI & Data Analysis
excel
Formulas and Functions
JadeHughes93's avatar
JadeHughes93
Copper Contributor
Dec 16, 2020

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.

 

HansVogelaar's avatar
HansVogelaar
MVP
Dec 16, 2020

JadeHughes93 

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")
  • JadeHughes93's avatar
    JadeHughes93
    Copper Contributor
    Dec 16, 2020

    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. 

    Thanks

    Jade

Resources