Home

I need help with one formula

%3CLINGO-SUB%20id%3D%22lingo-sub-659103%22%20slang%3D%22en-US%22%3EI%20need%20help%20with%20one%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-659103%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20this%20formula%26nbsp%3B%3DSUMAR.SI.CONJUNTO('.txt%20Data'!M%3AM%3B'.txt%20Data'!F%3AF%3BDataSheet!C52%3B'.txt%20Data'!G%3AG%3BDataSheet!E%245)%26nbsp%3B%20Where%20the%20sentence%20DataSheet!C52%20is%20taking%20the%20data%20from%20one%20Cell%20in%20another%20sheet%20in%20the%20same%20workbook%26nbsp%3B%3C%2FP%3E%3CP%3Enow%20I%20need%20to%20select%20from%20a%20couple%20of%20cells%2C%20I%20meant%20C52%26nbsp%3B%20have%20an%20value%20and%20I%20need%20for%20example%20select%20a%20couple%20of%20cells%20with%20different%20value%20(for%20example%20differents%20codes%20for%20the%20same%20Task)%20I%20would%20like%20to%20imput%20a%20sentence%20%22%20Take%20the%20data%20from%20%22DataSheet!%20%3CU%3Efrom%20Cells%20C52%20to%20C59%3C%2FU%3E%26nbsp%3B%20I%20don%C2%B4t%20know%20witch%20command%20can%20I%20put%20here%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20support%3C%2FP%3E%3CP%3EAntonio%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-659103%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-963185%22%20slang%3D%22en-US%22%3ERe%3A%20I%20need%20help%20with%20one%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-963185%22%20slang%3D%22en-US%22%3EHow%20to%20input%20formulas%3F%3C%2FLINGO-BODY%3E
Highlighted
Antonio J Fabian
New Contributor

I have this formula =SUMAR.SI.CONJUNTO('.txt Data'!M:M;'.txt Data'!F:F;DataSheet!C52;'.txt Data'!G:G;DataSheet!E$5)  Where the sentence DataSheet!C52 is taking the data from one Cell in another sheet in the same workbook 

now I need to select from a couple of cells, I meant C52  have an value and I need for example select a couple of cells with different value (for example differents codes for the same Task) I would like to imput a sentence " Take the data from "DataSheet! from Cells C52 to C59  I don´t know witch command can I put here

 

Thanks for your support

Antonio

1 Reply
Highlighted
How to input formulas?