Spreadsheet: 73685d1274293483-count-unequal-cells-with-2-conditions-if-workbook-2003-3
Sheet: Daily Sites  Status 

 | [NAME] analysis by reason
 | Region | Benghazi |  | Surt |  | Sebha |  | Total
 | Actual cause | Duration | Number of Down sites | Duration | Number of Down sites | Duration | Number of Down sites
 | AC Power - Libyana | 4849.200000000001 | 20 | 5959.3 | 8 | 0 | 0
 | BTS or NODE-B | 0 | 0 | 0 | 0 | 0 | 0
 | Transmission -MW- Libyana | 0 | 0 | 205.6 | 2 | 0 | 0
 | Transmission - Huawei | 733.1 | 5 | 167.5 | 1 | 0 | 0
 | Transmission - VSAT -Libyana | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
 | Transmission -Fiber- Libyana | 0 | 0 | 0 | 0 | 0 | 0
 | Air Condition | 0 | 0 | 0 | 0 | 0 | 0
 | Un - Authorized Activity | 0 | 0 | 0 | 0 | 0 | 0
 | DC Power - Huawei | 0 | 0 | 0 | 0 | 0 | 0
 | BSC or RNC | 0 | 0 | 0 | 0 | 0 | 0
 | Planned Activities | 0 | 0 | 0 | 0 | 0 | 0
 | Access Problem | 0 | 0 | 0 | 0 | 0 | 0
 | Transmission - DOMSAT - Libyana | 0 | 0 | 0 | 0 | 0 | 0
 | Total
 | Total Sites Down |  |  |  |  | I need count unequel number of sites with two conditions:
 | Site Name | Duration of Outage (Minutes) | Actual Cause | Region |  | Region and Actual Cause
 | MARJ037 | 32.5 | AC Power - Libyana | Benghazi
 | MARJ006 | 9 | AC Power - Libyana | Benghazi
 | BYDA024 | 276.3 | AC Power - Libyana | Benghazi
 | ADJU007 | 28.5 | Transmission - Huawei | Benghazi
 | ADJU004 | 28.5 | Transmission - Huawei | Benghazi
 | ADJU003 | 28.5 | Transmission - Huawei | Benghazi
 | [NAME] | 28.5 | Transmission - Huawei | Benghazi
 | ADJU008 | 28.5 | Transmission - Huawei | Benghazi
 | ADJU008 | 332.4 | AC Power - Libyana | Benghazi
 | ADJU004 | 332.4 | AC Power - Libyana | Benghazi
 | ADJU001 | 332.4 | AC Power - Libyana | Benghazi
 | ADJU007 | 332.4 | AC Power - Libyana | Benghazi
 | ADJU003 | 332.4 | AC Power - Libyana | Benghazi
 | AJDB005 | 332.4 | AC Power - Libyana | Benghazi
 | [NAME] | 332.4 | AC Power - Libyana | Benghazi
 | COAST052 | 57.3 | AC Power - Libyana | Surt
 | STRD002 | 827 | AC Power - Libyana | Surt
 | STRD001 | 827 | AC Power - Libyana | Surt
 | COAST054 | 827 | AC Power - Libyana | Surt
 | ZMZM001 | 827 | AC Power - Libyana | Surt
 | COAST053 | 827 | AC Power - Libyana | Surt
 | EMRH001 | 827 | AC Power - Libyana | Surt
 | BYDA011 | 300.3 | AC Power - Libyana | Benghazi
 | WDBD008 | 102.8 | Transmission -MW- Libyana | Surt
 | WDBD007 | 102.8 | Transmission -MW- Libyana | Surt
 | MARJ037 | 47.9 | AC Power - Libyana | Benghazi
 | MARJ006 | 24.6 | AC Power - Libyana | Benghazi
 | BGZ124 | 92.7 | AC Power - Libyana | Benghazi
 | COAST067 | 63.2 | AC Power - Libyana | Benghazi
 | ZMZM001 | 444 | AC Power - Libyana | Surt
 | COAST053 | 444 | AC Power - Libyana | Surt
 | TBRK009 | 49.4 | AC Power - Libyana | Benghazi
 | [NAME] | 244.4 | AC Power - Libyana | Benghazi
 | GBEB002 | 52 | AC Power - Libyana | Surt
 | COAST068 | 82.5 | AC Power - Libyana | Benghazi
 | HONE002 | 486 | BTS or NODE B | Surt
 | ADJU004 | 17.8 | Transmission - Huawei | Benghazi
 | ADJU008 | 17.8 | Transmission - Huawei | Benghazi
 | FZHA001 | 132 | AC Power - Libyana | Benghazi
 | ADJU004 | 555 | Transmission - Huawei | Benghazi
 | COAST200 | 52.9 | AC Power - Libyana | Benghazi
 | WSKA001 | 167.5 | Transmission - Huawei | Surt
 | QDBA001 | 545.1 | AC Power - Libyana | Benghazi
 | COAST068 | 103 | AC Power - Libyana | Benghazi
 | COAST017 | 466.6 | AC Power - Libyana | Benghazi