Nov 16 2019 07:49 AM
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?
Nov 16 2019 11:04 AM
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