Use COUNTIF to count values with one condition and SUMPRODUCT to count with
more than one condition

=COUNTIF(A2:A100,B2)

will count the value in cell B2 in A2:A100

=SUMPRODUCT(--(A2:A100=B2),--(C2:C100=D1))

will count B2 in A2:A100 and D2 in C2:C100

to remove #N/A from VLOOKUP result use

=IF(ISNA(MATCH(B2,D2:D100,0)),"",VLOOKUP(

Regards,

Peo Sjoblom



"Pauline" wrote in message
...
How do I use an Iserror Vlookup to count how many time a value appears,
subject to another column having specific data in it.