Count # of Open issues in another sheet

rlakin52911 · 07/05/18

Trying to count the total number of "open" and "Waiting" issues in a another sheet

=COUNTIF({Sheet - RAID Log Range 1} Status:Status, "Open")+COUNTIF (Status:Status, "Waiting")

Hitting a wall, getting an error. Anyone have some guidance?

p_bureau · 07/06/18

Hi,

if {Sheet - RAID Log Range 1} represents the column Status you want to count in, your formula should look more like this :

=COUNTIF({Sheet - RAID Log Range 1}, "Open")+COUNTIF ({Sheet - RAID Log Range 1}, "Waiting")

Does this help?

Best Regards,

Paul.

Paul Newcome · 07/06/18

You could also use =COUNTIFS({Sheet - RAID Log Range 1}, "Open", {Sheet - RAID Log Range 1}, "Waiting")

Comments