Forum Discussion

alanaj's avatar
alanaj
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 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

  • tauqeeracma's avatar
    tauqeeracma
    Iron 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

Resources