Forum Discussion

Copper Contributor

Nov 16, 2019

I need the Formual...

Hi there, I need the formulas for the blue and pink circle. Each of the highlighted fields are dances. If an X is placed in the cell that means the skater is dancing that particular dance and ...

excel

Formulas

tauqeeracma

Iron Contributor

Nov 16, 2019

HI alanaj

You may try below formula for Blue:

=COUNTA(E3:AQ3)*12

and for Pink use =COUNTA(E3:AQ3)*13

Please adjust row / column according to your data range.

Thanks

Tauqeer