Count # of Open issues in another sheet

rlakin52911

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

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

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