Syntax of COUNTIF() with 3 criteria

[fayez_MrExcel]

How can I use COUNTIF() with 3 criterias to meet. Example I want to count the number of employee who are "Resigned" under "H"R dept." and with "Indian Nationality". My table is: A1-Emp Name B1-Status(Resigned or Active), C1-Department, D1-Nationality...help please

 

[Scott Huish]

Try this:

=SUMPRODUCT(--(B1:B1000="Resigned"),--(C1:C1000="HR"),--(D1:D1000="Indian"))

 

[fayez_MrExcel]

Thanks a lot

 

[fayez_MrExcel]

The formula works okay thanks for that...what if i wanted to change one of the criteria, let us say all employee number that starts to 1. thanks

 

[ADAMC]

I believe you have had the answer to this question in another post you have raised AFTER this one:

http://www.mrexcel.com/board2/viewtopic.php?t=285131

 

[fayez_MrExcel]

Thanks