=SUMPRODUCT(--(A1:A100="Something in Col A"),--(B1:B100="Something in B"))

Change 100 to last row in your data set and conditions to what you want or a
cell reference.

"dave230" wrote:

I have a worksheet and I would like to query and count the number of records
by looking at 2 different colums and picking those records which contain the
required data in both.