Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1518101%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518101%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20the%20sum%20of%20Coloum%20M%20in%20my%20excel%20sheet%20to%20appear%20in%20a%20particular%20cell%20in%20coloum%20B.%3C%2FP%3E%3CP%3EWhat%20is%20the%20formula%20for%20that%3F%3C%2FP%3E%3CP%3EI%20need%20the%20sum%20of%20whatever%20numbers%20i%20write%20across%20any%20cell%20in%20coloumn%20M%20to%20appear%20in%20the%20particular%20cell%20in%20Coloumn%20V%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1518101%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518144%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518144%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F726635%22%20target%3D%22_blank%22%3E%40johnyjoy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20not%20upload%20a%20sample%20file%20and%20mock%20up%20the%20desired%20output%20manually%20to%20show%20us%20what%20exactly%20you%20are%20trying%20to%20achieve%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1518164%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1518164%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F726635%22%20target%3D%22_blank%22%3E%40johnyjoy%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20take%20the%20question%20literally%2C%20the%20answer%20could%20be%20-%20let%20take%20V5%20as%20particular%20cell%20in%20column%20V%20and%20enter%20into%20it%20formula%20%3DSUM(M%3AM)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I want the sum of Coloum M in my excel sheet to appear in a particular cell in coloum V.

What is the formula for that?

I need the sum of whatever numbers i write across any cell in coloumn M to appear in the particular cell in Coloumn V 

2 Replies
Highlighted

@johnyjoy 

Why not upload a sample file and mock up the desired output manually to show us what exactly you are trying to achieve?

Highlighted

@johnyjoy 

If take the question literally, the answer could be - let take V5 as particular cell in column V and enter into it formula =SUM(M:M)