Hi all,
I am currently working on a turnover report and i am having some problems using the countif formula to count e.g. the number of staff resigning on a certain month with a certain title.
<tbody>
</tbody>I tried to search online and found that I will have to use SUMPRODUCT instead of COUNTIF for this matter as there are the month column and text column. However, I have not too familiar with this function.
Can anyone help so that i can have the result of:
in January, there are 1 Sales Associate leaver and 1 Senior Sales leaver and 1 Sales Associate leaver in Apr
Note that I only look at the month instead of the date.
thanks for your help in advance
I am currently working on a turnover report and i am having some problems using the countif formula to count e.g. the number of staff resigning on a certain month with a certain title.
A | B | |
1 | Title | Last day of work |
2 | Sales Associate | 25-Jan-15 |
3 | Sales Associate | 16-Apr-15 |
4 | Senior Sales | 27-Jan-15 |
<tbody>
</tbody>
Can anyone help so that i can have the result of:
in January, there are 1 Sales Associate leaver and 1 Senior Sales leaver and 1 Sales Associate leaver in Apr
Note that I only look at the month instead of the date.
thanks for your help in advance