Hi,

I would like to your kind assistance on the following

My worksheet has multiple columns

Column F - date (format dd-mmm)
Column K - product name e.g. PIL, DCPIL etc
Column X - status =1

Column F Column K Column X
1-Mar PIL 1
3-Mar DCPIL 1
15-Mar PIL 1
20-Mar PIL 1
30-Mar DCPIL 1
2Apr PIL 1

Can anyone help to advise the formula (is it possible to use COUNTIF) on how to count the number of status = "1" for the period (1 Mar-15 Mar) with product name "PIL"
The answer I want should be "2"

Thanks

Pjlau