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!