Hello everyone, 

I need to make a counting table using datas from an other table like shown in the picture under. I’ve tried NB SI ENS formulas with for exemple : =NB si ens ($D$6:$D$29;H5=D7; $E$6:$E$29;E7=G6) but it doesn’t work. It’s in reality a big table with > 250 columns and > 20 lines to fill. 

Would you have an idea on how to make it with a single formula please ? 

Edit : NB SI is the french equivalent of COUNT IF

Thank you very much, 

Arnaud 

​Hello everyone, I need to make a counting table using datas from an other table like shown in the picture under. I’ve tried NB SI ENS formulas with for exemple : =NB si ens ($D$6:$D$29;H5=D7; $E$6:$E$29;E7=G6) but it doesn’t work. It’s in reality a big table with > 250 columns and > 20 lines to fill. Would you have an idea on how to make it with a single formula please ?  Edit : NB SI is the french equivalent of COUNT IFThank you very much,  Arnaud   Read More

​