SOLVED
Home

Help with Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-811273%22%20slang%3D%22en-US%22%3EHelp%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811273%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20working%20on%20formulating%20an%20excel%20sheet%20and%20want%20to%20use%20rep%20codes%20to%20label%20certain%20rows%20and%20numbers.%20For%20example%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%3E%3CTBODY%3E%3CTR%3E%3CTD%3E205%3C%2FTD%3E%3CTD%3EG%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E305%3C%2FTD%3E%3CTD%3EG%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E405%3C%2FTD%3E%3CTD%3EM%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20be%20able%20to%20have%20a%20formula%20that%20calculates%20the%20%22G%22%20total%20and%20then%20the%20%22M%22%20total%20on%20a%20different%20sheet.%20How%20am%20I%20able%20to%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-811273%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-811295%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811295%22%20slang%3D%22en-US%22%3EFor%20each%20rep%20code%2C%20just%20change%20the%20%22G%22%20in%20the%20following%20formula%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3DSUMIF(B%3AB%2C%22G%22%2CA%3AA)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-811328%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-811328%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%20do%20I%20get%20it%20to%20Sum%20the%20total%3F%20When%20I%20do%20that%20formula%20it%20is%20not%20adding%20the%20numbers%20together.%3C%2FP%3E%3C%2FLINGO-BODY%3E
admin2019
New Contributor

I am working on formulating an excel sheet and want to use rep codes to label certain rows and numbers. For example, 

 

205G
305G
405M

 

I want to be able to have a formula that calculates the "G" total and then the "M" total on a different sheet. How am I able to do this? 

2 Replies
Solution
For each rep code, just change the "G" in the following formula:

=SUMIF(B:B,"G",A:A)

@PReagan How do I get it to Sum the total? When I do that formula it is not adding the numbers together.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 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