Problem with if function

[Alessandro Correlli]

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

[#2]

Hi,

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

Please check out this link to learn this function.

Hope that helps