Help!

%3CLINGO-SUB%20id%3D%22lingo-sub-2335560%22%20slang%3D%22en-US%22%3EHelp!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335560%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20So%20this%20is%20for%20school%2C%20I%20need%20to%20use%20the%20If%20Function%20for%20Column%20E%20down%2C%20getting%20the%20total%20for%20the%20rings%20with%20the%20personalizing%20surcharge%20if%20they%20have%20it...%20I%20cannot%20get%20the%20correct%20price%20for%20some%20reason%2C%20plz%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2335560%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335686%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335686%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1047996%22%20target%3D%22_blank%22%3E%40notoriouslyinsane%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBetter%20if%20you%20share%20workbook%20with%20the%20same%20information.%20Where%20is%20IF()%20and%20what%20exactly%20you'd%20like%20to%20calculate%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2335696%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2335696%22%20slang%3D%22en-US%22%3EThe%20IF%20function%20is%20under%20the%20Logical%20Formulas%2C%20I%20think%20my%20Capture%20Image%20should%20work%20now..I%20need%20to%20calculate%20the%20total%20cost%20of%20the%20ring%20type%2C%20which%20includes%20a%20personalized%20surcharge%20if%20the%20students%20want%20is%20personalized.%3C%2FLINGO-BODY%3E
New Contributor

Hi! So this is for school, I need to use the If Function for Column E down, getting the total for the rings with the personalizing surcharge if they have it... I cannot get the correct price for some reason, plz help. 

3 Replies

@notoriouslyinsane 

Better if you share workbook with the same information. Where is IF() and what exactly you'd like to calculate?

The IF function is under the Logical Formulas, I think my Capture Image should work now..I need to calculate the total cost of the ring type, which includes a personalized surcharge if the students want is personalized.

@notoriouslyinsane 

Have no idea where the Logical Formulas are, but total cost you may calculate by formula like

=SUMIFS(<cost>, <RingType column>, <RingType>)