1

Good Evening. I am trying to count how many offices each company has in each country. For instance, 24 Hour Fitness has office as follows:

China 2
Hong Kong 6
etc.

I can subtotal it, but I want it in its own column. I have tried to do this in sections, but it takes to long as the entire sheet has over 168K rows. Can someone please give me a hand?

Spreadsheet Snapshot]

CallumDA
  • 12,025
  • 6
  • 30
  • 52
Anthony Russo
  • 13
  • 2
  • PS I have a pivot table on another sheet. I can list the locations, but not total them individually. this could be another option. – Anthony Russo Mar 20 '17 at 23:40
  • 1
    Pivot table should work? Just drag Parent Company and Location into the Row field and then Country into the Value field – CallumDA Mar 20 '17 at 23:49
  • I tried that, I thought it would as well. It did not for some reason. I am not sure why though. – Anthony Russo Mar 21 '17 at 02:30

1 Answers1

0

Does this work for you? Place in C2 and drag down

=COUNTIFS(A:A,A2,B:B,B2)
CallumDA
  • 12,025
  • 6
  • 30
  • 52