I want to maintain a database with list of issues, their severity and their
status...i have three columns.

On the top i'need to sum up all the issues with the severity "Critical" and
the status is "Open" similarly "Critical" and "Closed" status - i'm unable to
combine two condictions originating from a range...EX.

Issue         Severity         Status

1.            Highest             Open
2.            Critical              Closed
3.            Highest             Closed
4.            Critical              Closed
5.             Critical             Open

EXPECTED RESULT

CRITICAL ISSUES OPEN       = 1
CRITICAL ISSUES CLOSED  =  2
HIGHEST ISSUES OPEN         =  1
HIGHEST ISSUES CLOSED     = 1

Any form of help would be appreciated.

Thanks and Regards,