Thanks Vergel,

That worked well for totals. let me throw a monkey wrench into the mix.
What if I wanted to compare multiple values in the same matrix. IE what if I
wanted to count how many times Edmonton appears with Toronto on the same row?
Or let's say I've got another column to add that has nothing to do with the
locations it's merely identifying a value like Yes or No?

Let me know if you need clarification but more importantly... Thanks again!

"Vergel Adriano" wrote:

Bill,

This doesn't seem like exactly what you're looking for, but I hope it helps.
Assuming your matrix is in A1:C6, this will give you the number of cells
with "ETL London"

=COUNTIF(A16:C18,"ETL London")




"Bill D. Toronto" wrote:

I've got a matrix of locations. I want to count each time that the location
appears in the range.
E.g.
ETL London ETO Ottawa ETT Toronto
MTE Edmonton MTN Mountain Time North MTC Calgary
ETT Toronto ETL London CTW Winnipeg
ATF Fredericton ATC Charlottetown ATJ St John's
ATC Charlottetown ATF Fredericton ATH Halifax
ATC Charlottetown ATF Fredericton ATH Halifax

What is the best way to find out how many times that each city appears in
the list? Should I use pivot charts??? or is it an worksheet function that
will do the trick?
Many thanks,