I have a two part question.

Part 1 - I need to get the count based on the criteria in two columns,
In the below
example I am looking for a formula that will give me the count for
defects
that are having the status of OPEN and where there is ANY VALUE in the
severity column.

Defect# Status Severity
1 Open Critical
2 Closed
3 Open Important
4 Closed
5 Open Minor
6 Open Critical
7 Closed
8 Open Important
9 Closed Critical
10 Open Minor

Part 2 - I would like to know how to create a count based on multiple
criteria where a value is such and the second value is "not ____". For
example, a count where Status is open and severity is NOT Minor. Is
this possible using Excel 2003?

Thanks in advance!