Count a Column Refrencing another column

[red98]

For the life of me I cannot remember how to do this and I know it is easy!!

I need a formula that refrences Text in column A but counts the corrosponding row in another column.

So John Smith's total for Owner would be 1 and for Logistics it would be 4.

Stacy Jones' total for Owner would be 2 and for Logistics it would be 3

Steve Henry's total for Owner would be 0 and for Logistics it would be 4
[TABLE="width: 332"]
<COLGROUP><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><COL style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 3218" span=2 width=88><TBODY>[TR]
[TD="class: xl66, width: 82, bgcolor: transparent, align: left"]Individual[/TD]
[TD="class: xl66, width: 86, bgcolor: transparent, align: left"]Owner[/TD]
[TD="class: xl66, width: 97, bgcolor: transparent, align: left"]Logistics[/TD]
[TD="class: xl67, width: 88, bgcolor: transparent, align: left"] Budget [/TD]
[TD="class: xl67, width: 88, bgcolor: transparent, align: left"] Actual [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]John Smith[/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 37,889.00 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 36,358.12 [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]John Smith[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 198,889.00 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 156,723.53 [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]John Smith[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 59,766.00 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 53,328.45 [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]John Smith[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 66,889.00 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 56,016.88 [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]Stacy Jones[/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 98,889.00 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 131,974.62 [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]Stacy Jones[/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 85,739.00 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 85,339.96 [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]Stacy Jones[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 58,889.00 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 41,592.75 [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]Steve Henry[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 50,643.00 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 36,748.86 [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]Steve Henry[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 143,889.00 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 133,075.74 [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]Steve Henry[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 26,858.79 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 17,964.34 [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent, align: left"]Steve Henry[/TD]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl68, bgcolor: transparent, align: left"]yes[/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 698,889.00 [/TD]
[TD="class: xl69, bgcolor: transparent, align: left"] $ 698,889.00 [/TD]
[/TR]
</TBODY>[/TABLE]

 

[Firefly2012]

In xl2007+ that's COUNTIFS:

=COUNTIFS(A:A,"John Smith",B:B,"Yes")

the criteria above could be references to cells holding those values.

 

[Special-K99]

Maybe
=SUMPRODUCT(--(A2:A11="John Smith")*(B2:B11="yes"))
or Pivot Tables perhaps