Multiple Variations

a5972s

Board Regular
Joined
Aug 29, 2003
Messages
71
AJS.xls
BCDEF
2Condtion1Condition2
3DEPTALIVE
4DEPTBUAT
5DEPTCDEV
6DEPTDTEST
7DEPTATEST
8DEPTBDEV
9DEPTCUAT
10DEPTDLIVE
11DEPTALIVE
12DEPTBDEV
13DEPTCTEST
14DEPTDUAT
15
16
17
18
19
20
21LIVEUATDEVTEST
22DEPTA21
23DEPTB12
24DEPTC111
25DEPTD111
26
273333
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?
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

a5972s

Board Regular
Joined
Aug 29, 2003
Messages
71
Haven't used them before, but just had a play with them and OMG !!!

Pivot tables rock !!!
 

Watch MrExcel Video

Forum statistics

Threads
1,114,061
Messages
5,545,763
Members
410,704
Latest member
Cobber2008
Top