Count one piece of data but only if a second criteria is met

Hello,

Sorry if this has been posted before.

I'm looking for a formula that shows one piece of data but only if another criteria is met. Eg Column A1:A:100 show a piece of paperwork has been issued and column E1:E100 show the area that it's been issued to (North, South, East, Central)

I have a blank work sheet showing various % of things being late as a whole but also want to break this down into the four areas.

This is probably really simple but I've tried everything!

Thanks,
Craig

Impossible to help you.

Post your spreadsheet.

Try something like: =COUNTIFS(A:A,"issued",E:E,"north")

This is great thanks! I've been playing around with the COUNTIFS function based on your formula above and it worked! =COUNTIFS('E DIV'!H3:H114,"*",'E DIV'!R3:R114,"north")

My Next issue is that it works on mu excel but the office only has excel 2000 and COUNTIFS doesn't work! Any suggestions as what to use in its place?