Forum Discussion
Caroline Schmitt
Jun 27, 2018Copper Contributor
count if 2 criterias ( 1 date, 1 text)
Hello,
I try to create some statistics about trainings.
I have 1 column about the kind of training. ( Column 1)
I have an other column about the end date of the training.
I want to count for each month, the number of training ending regarding the kind of training.
FOr exemple : I want to count the training "digital" ending in January 2018.
Can you help me please?
Thank you in advance,
Hi Caroline,
I guess you may use COUNTIFS https://support.office.com/en-us/article/countifs-function-dda3dc6e-f74e-4aee-88bc-aa8c2a866842