Which formula?

[Mary7903]

I Have a spreadsheet with following:

Column A = site names (x,y...)
Column B = staff name (Mary....)
Column C = dates
Column D =?
Column E =?


I need to show on column D how many times any staff travelled to site x

Then on column E, I would like to show how many times Mary travelled to any of the sites.

I’m trying to use countif formula but is not working ?. Could someone please provide the formula. Thank you

 

[MUKESHY12390]

I need to show on column D how many times any staff travelled to site x
---- just for X or it would be changing depending upon situation.

And why you don't just use PivotTable and GETPIVOTDATA?

How you are using formula , can you post it.


Regards,
Mukesh Y

 

[dave2018]

Excel 2016 (Windows) 32 bit
	A	B	C	D	E
1	Site	Staff	Dates	Site Total	Staff Total
2	C	William		1	6
3	L	John		3	7
4	N	Jim		1	2
5	V	John		2	7
6	Z	John		3	7
7	P	Jim		2	2
8	Z	Mary		3	3
9	D	Sioux		1	6
10	K	Sioux		1	6
11	O	Sioux		2	6
12	I	John		1	7
13	H	Sioux		1	6
14	J	John		1	7
15	E	Mary		4	3
16	S	John		2	7
17	S	James		2	5
18	G	James		2	5
19	L	William		3	6
20	G	William		2	6
21	V	William		2	6
22	Q	Sioux		1	6
23	E	William		4	6
24	P	Mary		2	3
25	L	James		3	5
26	E	Sioux		4	6
27	B	John		1	7
28	O	James		2	5
29	Z	James		3	5
30	E	William		4	6
Sheet5

Cell Formulas
Range	Formula
D2	=SUMPRODUCT(--($A$2:$A$30=A2))
E2	=SUMPRODUCT(--($B$2:$B$30=B2))