Hi,

I'm having problems getting the right formula to suit what I need.

Basically I have a large spreadsheet containing many records and I want to
count the number of records that meet three specific types of criteria.

e.g.

Column A = Type
Column B = Status
Column C = Ref No. (i.e. 1.06)

The above columns have many different entries, therefore I would like to
count the number of records which meet the following criteria. No of Records
= Type A, Status X, Ref 1.06.

I have used SUMProduct, CountIF and etc but I don't seem to be doing it
correctly.

I have done this using PivotTables but I would like to add this formula to
another data table, hence the formulae question.

Many thanks in advance.