k1ghtt3mplar
New Member
- Joined
- Sep 12, 2017
- Messages
- 3
Hello all,
I am wanting to count cells that meet criteria in a sheet (data).
The Data sheet, column A contains, DD-MMM-YY and column H contains different text, xxx, yyyyy,zzz for example.
I wish to count how many xxx (column H) are in specific month and year (e.g. Jan-14 using the info from column A on to a collection sheet. In addition the same to be applied for yyyyy and zzz. This will span from jan 14 to a future date Jan 19. So when information is added to the data sheet the table on collection sheet auto populates.
thankyou in advance if anyone can help.
I am wanting to count cells that meet criteria in a sheet (data).
The Data sheet, column A contains, DD-MMM-YY and column H contains different text, xxx, yyyyy,zzz for example.
I wish to count how many xxx (column H) are in specific month and year (e.g. Jan-14 using the info from column A on to a collection sheet. In addition the same to be applied for yyyyy and zzz. This will span from jan 14 to a future date Jan 19. So when information is added to the data sheet the table on collection sheet auto populates.
thankyou in advance if anyone can help.