| AJS.xls | |||||||
|---|---|---|---|---|---|---|---|
| B | C | D | E | F | |||
| 2 | Condtion1 | Condition2 | |||||
| 3 | DEPTA | LIVE | |||||
| 4 | DEPTB | UAT | |||||
| 5 | DEPTC | DEV | |||||
| 6 | DEPTD | TEST | |||||
| 7 | DEPTA | TEST | |||||
| 8 | DEPTB | DEV | |||||
| 9 | DEPTC | UAT | |||||
| 10 | DEPTD | LIVE | |||||
| 11 | DEPTA | LIVE | |||||
| 12 | DEPTB | DEV | |||||
| 13 | DEPTC | TEST | |||||
| 14 | DEPTD | UAT | |||||
| 15 | |||||||
| 16 | |||||||
| 17 | |||||||
| 18 | |||||||
| 19 | |||||||
| 20 | |||||||
| 21 | LIVE | UAT | DEV | TEST | |||
| 22 | DEPTA | 2 | 1 | ||||
| 23 | DEPTB | 1 | 2 | ||||
| 24 | DEPTC | 1 | 1 | 1 | |||
| 25 | DEPTD | 1 | 1 | 1 | |||
| 26 | |||||||
| 27 | 3 | 3 | 3 | 3 | |||
Sheet1 | |||||||
I'd like a formula similar to 'COUNTIF' that would be able to calculate 2 conditions and display the results in a 3rd column. The table below is just my workings out!
So basically a formula that calculates how many LIVE, TEST, DEV & UAT each dept has. Both columns are fluid each month, so they may be 10 item, there maybe more.
Can anyone help?
