ranjith’s solution is awesome (I didn’t know the method he use), but I have another option.
How about using DataTableName.Select method for each keyword to filter it and count the number of selected rows after Read Range?
DataTable.Select returns an array of DataRows, so you can know how many rows matched the criteria by ArrayName.Length.
I’ll try to create sample later.
Both must work fine, but I wanted to share this option because I think this would be better way when the Excel file becomes huge; it took me about 30 min when I iterated through an Excel file which contains 4000+ rows by using for each row to check if certain column matches condition, while DataTable.Select took only a few.