Excel Division Fotmulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1589524%22%20slang%3D%22en-US%22%3EExcel%20Division%20Fotmulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589524%22%20slang%3D%22en-US%22%3EI%20am%20creating%20an%20Excel%20spreadsheet%20on%20my%20cell%20phone%20using%20Office%20365.%20I%20am%20trying%20to%20divide%20the%20sum%20of%20entries%20in%20one%20column%20by%20the%20sum%20of%20entries%20in%20another%20column%20to%20get%20a%20percentage.%20I%20have%20tried%20many%20different%20formulas%20but%20cannot%20get%20one%20to%20work.%20Attached%20is%20a%20screenshot%20of%20the%20most%20recent%20attempt.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1589524%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1589537%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Division%20Fotmulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1589537%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F759998%22%20target%3D%22_blank%22%3E%40Dompedrito%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM(C40%3AC46)%2FSUM(E40%3AE46)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I am creating an Excel spreadsheet on my cell phone using Office 365. I am trying to divide the sum of entries in one column by the sum of entries in another column to get a percentage. I have tried many different formulas but cannot get one to work. Attached is a screenshot of the most recent attempt.
1 Reply

@Dompedrito 

It's

=SUM(C40:C46)/SUM(E40:E46)