Countifs, with a cross reference and an or

PSetup

Hi there,

I'm trying to count how many red risks I have in my RAAIDD log that are not closed or complete. I've written the below, but I can't get it to work. Any advice would be gratefully received, please.

=COUNTIFS({NAME RAAIDD Range 1}, "Risk", {NAME RAAIDD Range 3}, ">=8", {NAME RAAIDD Status}, OR(@cell = "Open", @cell = "In progress", @cell = "On hold", @Cell = "Deferred"))

Thank you!

Leibel S

Try this:

=COUNTIFS({NAME RAAIDD Range 1}, @cell="Risk", {NAME RAAIDD Range 3}, @cell>=8, {NAME RAAIDD Status}, OR(NOT(@cell = "Closed"), NOT(@cell = "Complete")))

Leibel S

Try this:

=COUNTIFS({NAME RAAIDD Range 1}, @cell="Risk", {NAME RAAIDD Range 3}, @cell>=8, {NAME RAAIDD Status}, OR(NOT(@cell = "Closed"), NOT(@cell = "Complete")))

PSetup

Thank you so much, it worked!!

PSetup

I've looked at this again today and have realised that it wasn't paying attention to any of the "Not" items, so is counting any red risk or issue, whether they're open or not. I've used Summary fields instead and will use the summary reporting to pull everything together in to one dashboard.