I need to be able to calculate how many of the R1, Open, risks are passed their due date and have a Risk Score of more than 20
and
I need to be able to calculate how many of the R1, Open, risks are not passed their due date and have a risk score of more than 20
I can do most of it but not sure how to use COUNTIFS when it involves dates in this way.
I've attached a sheet with the data.
Thank you.
You don't appear to have any items in the table with a risk score more than 20. However, this *should* work if you do:
WBD
Please Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
the first one is =COUNTIFS(Table_query__15[RiskScore],">20",Table_query__15[PlannedClosureDate],"<"&TODAY())
your language is not clear
the first one is =COUNTIFS(Table_query__15[RiskScore],">20",Table_query__15[PlannedClosureDate],">"&TODAY())
but both ignore today, you have not said which group if falls in or if ti si ignored you may need to change to <= or >= in the above formulas
Thank you for reply so super quickly.
If the risk score is between 19 and 10, how would I edit the formulae to take that into account?
Add more conditions to the formula. For example:
WBDPlease Login or Register to view this content.
Thank you for your help, I'll test it with some higher numbers to see if it works for me. (If Ive added the right formula)
Last edited by Mccollantics2022; 10-04-2022 at 08:26 AM.
I can't get this to work. :-(
Found the issue! All working now, thankyou
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks