"Risky Dave" wrote:

I think that my question is similar to Sami's, below, if so my apologies, but
I didn't understand the response.

I need to count the number of entries that meet a set of criteria across
multiple cells. For example:

number date1 New Text Text Data1
number date1 Old Text Text Data1
number date2 Middle Text Text Data2
number date3 New Text Text Data2
number date1 Old Text Text Data1

I need to find out how many rows have date1, Old, Data1 in the appropriate
fields (here, the result would be 2). The result will be sent to another
worksheet and the source data has been exported from Access.

I cannot sort the fields first as there will be multiple counts using
different criteria and I am trying to automate the process.

I do not need to know the actual data in any of the fields, just the number
of records that match my criteria.

Any suggestions would be much appreciated.

Gents, an elegant and effective solution - my thanks.
Roger, I did have to use the date function as well.