Use things like:

=SUMPRODUCT((B1:B5="Highest")*(C1:C5="Open"))

--
Gary''s Student
gsnu200710


"Kannan UGS" wrote:

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,