Home

I need the Formual...

%3CLINGO-SUB%20id%3D%22lingo-sub-1013170%22%20slang%3D%22en-US%22%3EI%20need%20the%20Formual...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1013170%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20the%20formulas%20for%20the%20blue%20and%20pink%20circle.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20of%20the%20highlighted%20fields%20are%20dances.%20If%20an%20X%20is%20placed%20in%20the%20cell%20that%20means%20the%20skater%20is%20dancing%20that%20particular%20dance%20and%20therefore%20the%20cost%20of%20that%20dance%20is%20%2412.%20If%20they%20are%20skating%20more%20than%20one%20dance%20then%20for%20however%20many%20X's%20are%20in%20that%20row%20times%2012%20is%20what%20is%20to%20be%20calculated%20in%20the%20Blue%20circle.%20i%20need%20the%20formula%20for%20that%20.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20essentially%20in%20the%20pink%20circle%20as%20well%20except%20that%20cost%20is%20%2413%20per%20dance.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20teach%20me%20how%20to%20write%20these%20formulas%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1013170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1013298%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20the%20Formual...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1013298%22%20slang%3D%22en-US%22%3E%3CP%3EHI%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F459672%22%20target%3D%22_blank%22%3E%40alanaj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20try%20below%20formula%20for%20Blue%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DCOUNTA(E3%3AAQ3)*12%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20for%20Pink%20use%26nbsp%3B%3D%3CSTRONG%3ECOUNTA(E3%3AAQ3)*13%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EPlease%20adjust%20row%20%2F%20column%20according%20to%20your%20data%20range.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

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