COUNTIFS question

[faisalm2]

Hi Guys

I got a query regarding counting specific dates within a month and I want the countif to be done a specific condition.

The example

A tutor (one condition) is teaching a specific course (second condition) and she does this course multiple times a year and I want a formula to count how many student they have for a particular course and tutor. The formula that I am currently using works but it's long to copy for all the tutors and courses. I want to know a quicker method. I have pasted the formula below that I am currently using.

=COUNTIFS('May - Data'!E:E, "English", 'May - Data'!F:F, "DS", 'May - Data'!H:H, ">"&"01/05/2017",'May - Data'!H:H,"<"&"01/06/2017")

 

[steve the fish]

You can replace your criteria with cell references. You dont need to change the formulas then. You can just point it at different cells.

 

[faisalm2]

That is something I did think off. But it wouldn't work as I get data on a month by month basis.