Forum Discussion

Alessandro Correlli's avatar
Alessandro Correlli
Copper Contributor
Oct 13, 2018

Problem with if function

Need some help !

 

I have that issue :

 

A secretary has to encode some datas for a student inscription

 

My issue is, how is it possible when she will choose, for example, 'Math' on J or K column, and 'Module 2' on L column, to have a +1 automatically done on R6? Max inscription for each 'module' = 6.

 

Example :

 

Two students choose 'math' on 'module 2', R6 = 2/6

Four students choose 'math' on 'module 2', R6 = 4/6

 

Thanks in advance for your help

 

 

excel
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Oct 13, 2018

    Hi,

     

    I think she uses COUNTIF function in the Module 2 table!

    Please check out this link to learn this function.

     

    Hope that helps

Resources