CountIF Multiple Criteria

[pyroto]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD] A[/TD]
[TD]B[/TD]
[TD] C[/TD]
[TD]D[/TD]
[TD] E[/TD]
[TD] F[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Store #[/TD]
[TD]Number of Visits[/TD]
[TD][/TD]
[TD]Name[/TD]
[TD]Count of Visits[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD] 1542[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]Joe[/TD]
[TD] 3[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]1872[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]Brad[/TD]
[TD] 2[/TD]
[/TR]
[TR]
[TD]Joe[/TD]
[TD]1932[/TD]
[TD]3[/TD]
[TD][/TD]
[TD]Sarah[/TD]
[TD] 3[/TD]
[/TR]
[TR]
[TD]Brad[/TD]
[TD]5323[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Brad[/TD]
[TD]2142[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sarah[/TD]
[TD]6745[/TD]
[TD]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sarah[/TD]
[TD]0896[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sarah[/TD]
[TD]3242[/TD]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sarah[/TD]
[TD]5735[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


For the Column F I would like to return the count of stores each person visited. So Looks for Joe in Column A and COUNTS > 0 in Column C.


Just having a brain lapse today.


Thanks in advance.
-Rob

 

[jtakw]

Hi,

If your Column B won't be duplicated for the same person for the same store:

Book1
	A	B	C	D	E	F
1	Name	Store #	Number of Visits		Name	Count of Visits
2	Joe	1542	3		Joe	3
3	Joe	1872	4		Brad	2
4	Joe	1932	3		Sarah	3
5	Brad	5323	2
6	Brad	2142	3
7	Sarah	6745	0
8	Sarah	896	2
9	Sarah	3242	3
10	Sarah	5735	1
Sheet149

Cell Formulas
Range	Formula
F2	=COUNTIFS(A$2:A$10,E2,C$2:C$10,"<>0")

Formula copied down.

 

[pyroto]

Thank you so much!!!

 

[jtakw]

You're very welcome.