How to count multiple name base of date criteria.

[Nitesh Kumar]

Hi,


Kindly suggest me how to count multiple name (Orange and Mango) based on given date
criteria 03/11/2016, PFA.

 

[NARAYANK991]

Hi ,

Try this :

=SUM(COUNTIFS($B$2:$B$11, {"ORANGE","MANGO"}, $A$2:$A$11, $D$8))

Narayan