How to Exclude Certain Parameters

[EfficientOne]

Hello,
Am attempting to report tickets that are currently open and were created within a certain time range. The problem arises when I attempt to eliminate items that were opened and closed within the same date range.

The current formula is =COUNTIF('name of tab'!$B$!:$B$100, "1") where 1 equals Critical, 2 equals High, 3 equals Medium, etc

This formula returns everything and I only want to show those with an open status (i.e Acknowledged, Open, In Progress, etc.) and not those with a status of Resolved or Closed.

Columns -
B: Priority
K: Status

What do I need to add for the formula to count how many of each priority are in each status (combined)?

Thank you.

 

[EfficientOne]

I mistyped. I do have that parentheses in the formula.

 

[VoG]

Working here

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	3	Request									Open
2		Request									Acknowledged
3		Request									In Progress
4		Request									xxx
5		ggg									Open
detail

 

[EfficientOne]

Thank you for the visual. As soon as I saw it I realized why it wasn't working. The K paramenters are different for those that have 'request' in B. Once I changed them it worked like a charm.

THANK YOU FOR EVERYTHING. YOU'RE THE BEST!