CountIF Multiple Criteria

[pyroto]

A	B	C	D	E	F
Name	Store #	Number of Visits		Name	Count of Visits
Joe	1542	3		Joe	3
Joe	1872	4		Brad	2
Joe	1932	3		Sarah	3
Brad	5323	2
Brad	2142	3
Sarah	6745	0
Sarah	0896	2
Sarah	3242	3
Sarah	5735	1

<tbody>
</tbody>

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.