| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting occurances and multiplying by a quantity | Excel Discussion (Misc queries) | |||
| Counting occurances in one column if another col. meets a certain | Excel Worksheet Functions | |||
| Counting Occurances | Excel Discussion (Misc queries) | |||
| counting occurances | Excel Worksheet Functions | |||
| Counting Date Occurances | Excel Worksheet Functions | |||
Linear Mode
