VBA Countifs where left of cell is tested?

[raven_squire]

Hello,

I have the code below that works as intended (except the last condition matches with Bananas for simplicity). I need to change it so that in adition to existing criteria it counts all alarms starting with "Ban". So it would count all the alarms for "Bananas", "Bandanas", "Bankrupt" etc etc etc I dont know how many different kinds of alarms start with "Ban". I dont know how to alter the cells in the range before comparing them. Any help would be apreciated.

Worksheets("Statistics").Cells(28, 2).Value = Application.WorksheetFunction.CountIfs(Worksheets("AlarmListing").Range("Table1[Date]"), ">=" & _
startDate, Worksheets("AlarmListing").Range("Table1[Date]"), "<=" & endDate _
, Worksheets("AlarmListing").Range("Table1[[Alarm Type]]"), "Bananas")


Thankyou

 

[James006]

Hello,

Have you tried to replace "Bananas" by "Ban" & "*" ... ?

HTH

 

[raven_squire]

Thank you for that

It had not occured to me to use a wild card and when I tested it it worked a treat.

Thanks again.

 

[James006]

You are welcome ...