Homework? Look in the archives or google for SUMPRODUCT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Neil Pearce" wrote in message
...
Hi all,

Column A, rows 2-99, contains the number of bedrooms a house contains,
e.g.
1, 2, 3 or 4.
Column B, rows 2-99, contains the number of storeys the house is, e.g. 1,
2,
3, 4

What formula would I use to count the nuber of 2 bedroom houses that are 3
storeys tall? =COUNTIF(A2:A99, AND???..

Please help, thank-you.

Kinf regards,

Neil