Microsoft Excel formula

Question

I am new to MS excel and trying to write a MS excel formula :

 

here I want to COUNT the number of TRUE and FALSE values 

an example of the scenario:

 

Functional Area	Test type
Multiple	FALSE
OS	TRUE
TPS	FALSE
OS	FALSE
Multiple	TRUE
Multiple	FALSE
TPS	TRUE
Multiple	TRUE
Multiple	FALSE
OS	TRUE
Multiple	TRUE
OS	FALSE
TPS	TRUE
OS	FALSE

 

 

Functional Area	TRUE	FALSE
Multiple
OIS
TPS

 

 what is the format of formula for the TRUE and FALSE cell

 

the code would be something like;

 

int count=0;

for(i=0;i< totalrows(functional area);i++)

{

 if(functiona area=="ÖIS"&&Test type=TRUE)

 

cell value=count++; 

 

}