Hi Lisa

one way

=SUMPRODUCT(--(A1:A1000="Manchester"),--(B1:B1000="Overdue"))

note however that you can not use A:A or B:B with SUMPRODUCT

for more details on how this function works check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Cheers
julieD


"Lisa" wrote in message
...
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!