Try

=SUMPRODUCT(--(A1:A100="equipment id"),--(B1:B100="Fail"))

With equipment id in cell C1

=SUMPRODUCT(--(A1:A100=C1),--(B1:B100="Fail"))

PS: Incase you are using XL2007 checkout help on COUNTIFS()


--
Jacob


"Chuckles" wrote:

Hi,

I have a spreadsheet with a large volume of data. I want to count how many
times the equipment id (column A) comes up with a specific fault (Column
B)i.e Fail.

There could be numerous entires for the same piece of equipment with
different types of faults.

I've tried count, countif etc... but cant get the formula to lookup the
value and count up the occurences properly.

Can anyone help?

Thanks.