ExcelBanter - Counting repeated occurances

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting repeated occurances (https://www.excelbanter.com/excel-worksheet-functions/134596-counting-repeated-occurances.html)

Kannan UGS

Counting repeated occurances

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,

Gary''s Student

Counting repeated occurances

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,

Teethless mama

Counting repeated occurances

Xl 2007

COUNTIFS(B:B,"Highest",C:C,"Open")

"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,

All times are GMT +1. The time now is 02:52 AM.