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
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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies