Hi Guys,

I'm trying to use the countif function to display the number of cells with certain text in them.

for example:

Column A will have either Car, Bike or Van in the cells and column B will have a date.

But I want to work out how many Car and Bike are on date 01/01/2015

This works: 
=COUNTIFS(A:A,"Car",B:B,"01/01/2015")+COUNTIFS(A:A,"Bike",B:B,"01/01/2015)
but is there an easier way for example (I have tried it but doesn't work): 
=COUNTIFS(A:A,{"Car","Bike"},B:B,01/01/2015)
I don't have to use the countif function if there is a better function/formula to use

Thanks for any help!