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?