Another way to summarize the data is by using a pivot table. There are
instructions in Excel's help, and some instructions and links he

http://peltiertech.com/Excel/Pivots/pivotstart.htm

Create a pivot table with Location in the row area, and Status in the
column area. Add another copy of Location to the Data area, where it
will become Count of Location.

Lisa wrote:
How can I COUNTIF values in Column A = "Manchester" AND values in column B =
"Overdue"
i.e I have a sheet with lots of locations in Column A, and Overdue or "OK"
in Column B, but i want to know how many overdues there arevfor particular
locations!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html