Automatically fill in cell with a number

[Deanyg1989]

Hi there I am currently looking for help with the following, I have spent two days looking at it and it is blowing my mind, I think it’s simple but clearly not.
I have the following letters in column D ‘A, B, C, D and E.’ In column I I have the following. ‘WTS+, WTS, EXS, GDS’
All I want to do is in cell N4, count the number of people who in column D have A and column I have WTS+.
Then in N5 the number of people with B and WTS+ in N6 the number of people with C and WTS+z etc etc. Once I know how to do one of them or the van for one I can then change it and add all scenarios.


Thanks in advance

 

[Deanyg1989]

Just to clarify I want one count for Col D and ColI together.

 

[Enzo_Matrix]

Try this:

=COUNTIFS($D:$D,"A",$I:$I,"WTS+")

You'll just have to change the "A" and the "WTS+" and it should work for the rest of your table

 

[jtakw]

Hi,

This formula will automatically change the first condition (A, B, C, D, E) as you copy the formula down Column N:

Excel 2010
	D	I	N
1	A	WTS+
2	B	WTS
3	C	EXS
4	D	GDS	1
5	E	WTS+	0
6			0
7			0
8			1
Sheet17

Cell Formulas
Range	Formula
N4	=COUNTIFS(D$1:D$5,CHOOSE(ROW(A1),"A","B","C","D","E"),I$1:I$5,"WTS+")