Hi all, hoping someone out there can help with a formula question.

I have a set of data similar to the following

A B C
D E

1 East West North East
North
2 45 40 51 35
20


Row 1 refers to the locality, and row two to the opening hours a week.

I want to be able to ask, how many places are in the east and are open less
than or equal to 40 hours a week (2 criteria), and then build on this by
asking how many places in the east are are open more than 40 hours a week and
less than 60 hours a week (3 criteria).
I have tried several versions of countif and sumproduct but all to no avail.
Would be far simpler to use countifs (as in 2007) but my employers only use
2003!
Any help very much appreciated.