I need the Formual...

Copper Contributor

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 therefore the cost of that dance is $12. If they are skating more than one dance then for however many X's are in that row times 12 is what is to be calculated in the Blue circle. i need the formula for that . 

 

and essentially in the pink circle as well except that cost is $13 per dance. 

 

Can someone teach me how to write these formulas? 

1 Reply

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