Forum Discussion
alanaj
Nov 16, 2019Copper Contributor
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 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
- tauqeeracmaIron Contributor
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