CountIF incorrect

Im trying to count the number of total number of "Open" "Risks" in another sheet

=COUNTIFS({RAID Log Range 1}, "Risk") + (COUNTIFS({RAID Log Range 2}, "Open"))

I only have 1 open risk but its returning 5. This is because its counting the total number of "open" AND "Risks" into my count. How do I write the formula to be explicit to only count Risks that are open?

Find more posts tagged with

Formulas

Comments

rlakin52911

Found it, this worked:

=COUNTIFS({RAID Log Range 2}, "Open", {RAID Log Range 1}, "Risk")

how would I add another option to Range 2

=COUNTIFS({RAID Log Range 2}, "Open" OR "Escalated", {RAID Log Range 1}, "Risk")

Show me all Risks that are Open or Escalated?

p_bureau

Hi,

when you want something like "OR" with a SUMIF, you need to add multiple SUMIF :

' =COUNTIFS({RAID Log Range 2}, "Open", {RAID Log Range 1}, "Risk") + COUNTIFS({RAID Log Range 2}, "Escalated", {RAID Log Range 1}, "Risk") '

Does this help ?

Best Regards,

Paul.

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…