Count a Column Refrencing another column

R

red98

New Member
Joined
Mar 27, 2008
Messages
9
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]
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Sort by date Sort by votes
In xl2007+ that's COUNTIFS:

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

the criteria above could be references to cells holding those values.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
VBA to filter on 2 columns and consolidate data into one row
2
Replies
17
Views
1K
Peter_SSs
Peter_SSs
A
  • Question Question
Add Sequence numbers Based on Dates
Replies
1
Views
3K
Jeffrey Mahoney
Jeffrey Mahoney
S
  • Question Question
Multiple Condition IF/OR Statement with TEXT
Replies
1
Views
1K
AlanY
A
H
  • Question Question
Macros - Auto Copy paste row when cell value changes
Replies
7
Views
6K
Fluff
Fluff
J
  • Question Question
pulling data from one chart to another
Replies
1
Views
830
jb00976
J

Forum statistics

Threads
1,226,735
Messages
6,192,733
Members
453,752
Latest member
Austin2222

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top