CountIFs number of entries which match two different variables between two dates

[Ghtdd]

Hi all,

I am looking to be able to count the number of entries between two dates which match two different variables.

In the example attached, I want a formula which will count the entry if it contains the relevant product AND Name of sales person.

My code at the moment is =CountIFS($A$2:$A$12,”>”&F$8,$A$2:$A$12,”<“&F$9,$C$2,$C$12,$E2,$B$2:$B$12,$B$15

It Will work fine if I just want to countif between two dates for one of these variables but not both.

Any help would be much appreciated!

 

[Fluff]

What makes you think it doesn't work?
Also it's better to post sample data to the board using the XL2BB add-in, rather than an image.

 

[Ghtdd]

What makes you think it doesn't work?
Also it's better to post sample data to the board using the XL2BB add-in, rather than an image.

You are correct, it does work, just a mistake. In future I will be sure to use that format, and ensure there is a genuine error. Apologies!

 

[Fluff]

Glad it's working & thanks for the feedback.