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!
Bookmarks