Counting repeated occurances

K

Kannan UGS

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top