Home

Excel Help

%3CLINGO-SUB%20id%3D%22lingo-sub-815478%22%20slang%3D%22en-US%22%3EExcel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815478%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20you%20connect%20information%20from%20one%20sheet%20to%20another%3F%20I%20have%20been%20using%20the%20formula%20SUMIF(A%3AA%2C%20%22M%22%2C%20B%3AB)%20to%20find%20the%20sum%20of%20information%20for%20rows%20represented%20with%20%22M%22.%20Is%20there%20a%20formula%20for%20me%20to%20transfer%20the%20information%20for%20rows%20labeled%20%22M%22%20or%20%22G%22%3F%20I%20want%20to%20arrange%20the%20information%20to%20divide%20the%20codes%20up%20to%20different%20sheets%20automatically%20without%20having%20to%20manually%20put%20in%20the%20information.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-815478%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-815561%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815561%22%20slang%3D%22en-US%22%3E%3DSUMIF(A%3AA%2C%20%22M%22%2C%20B%3AB)%2BSUMIF(A%3AA%2C%20%22G%22%2C%20B%3AB)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815576%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815576%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3Bhow%20will%20this%20make%20it%20transfer%20to%20other%20sheets%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815596%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815596%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394638%22%20target%3D%22_blank%22%3E%40admin2019%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20apologize%2C%20I%20must%20have%20misunderstood%20your%20question.%20Could%20you%20please%20provide%20a%20sample%20of%20what%20you%20are%20trying%20to%20achieve%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3EPReagan%3C%2FP%3E%3C%2FLINGO-BODY%3E
admin2019
New Contributor

How do you connect information from one sheet to another? I have been using the formula SUMIF(A:A, "M", B:B) to find the sum of information for rows represented with "M". Is there a formula for me to transfer the information for rows labeled "M" or "G"? I want to arrange the information to divide the codes up to different sheets automatically without having to manually put in the information. 

3 Replies
=SUMIF(A:A, "M", B:B)+SUMIF(A:A, "G", B:B)

@PReagan how will this make it transfer to other sheets?

@admin2019,

 

I apologize, I must have misunderstood your question. Could you please provide a sample of what you are trying to achieve?

 

Thank you!

PReagan

Related Conversations
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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies