SOLVED
Home

Excel Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-299353%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299353%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20looking%20for%20a%20formula%20that%20will%20use%20vlookup%20and%20sumif%20to%20sum%20a%20specific%20column%20based%20on%202%20criteria.%20The%20attached%20spreadsheet%20will%20make%20the%20task%20obvious.%26nbsp%3BI'd%20like%20to%20sum%20all%26nbsp%3Baccounts%20based%20on%20the%20Org%20unit%20which.%20I'd%20like%20to%20be%20able%20to%20change%20that%20Org%20Unit%2010%20to%20another%20org%20%23%20like%2020%20and%20the%20amount%20would%20change%20based%20on%20that.%20Please%20see%20attached%20excel%20sheet%20for%20a%20sample.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-299353%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314173%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314173%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F264499%22%20target%3D%22_blank%22%3E%40PromiseO1245%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20out%20the%20resources%20below%20that%20could%20be%20helpful%20to%20learn%20how%20to%20start%20using%20SUMIF%2FSUMIFS%20functions%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FSUMIF-function-169B8C99-C05C-4483-A712-1697A653039B%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESUMIF%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FSUMIFS-function-C9E748F5-7EA7-455D-9406-611CEBCE642B%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESUMIFS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314172%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314172%22%20slang%3D%22en-US%22%3EPlease%2C%20kindly%20teach%20me%20how%20to%20use%20those%20excel%20formula%20for%20calculation.%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299366%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299366%22%20slang%3D%22en-US%22%3EIt%20worked%2C%20thanks%20so%20much!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299363%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299363%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%20to%20SUMIFS%20function!%3C%2FP%3E%3CP%3ESo%2C%20I've%20updated%20the%20workbook%20with%20this%20formula%3A%3C%2FP%3E%3CPRE%3E%3DSUMIFS(Data!%24C%242%3A%24C%24510%2CData!%24B%242%3A%24B%24510%2CA5%2CData!%24A%242%3A%24A%24510%2C%24A%242)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20please%20note%20that%20there%20are%20some%20duplicate%20numbers%20in%20Sheet1%20%2F%20New%20Account%20Number%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E
Edins425
New Contributor

I'm looking for a formula that will use vlookup and sumif to sum a specific column based on 2 criteria. The attached spreadsheet will make the task obvious. I'd like to sum all accounts based on the Org unit which. I'd like to be able to change that Org Unit 10 to another org # like 20 and the amount would change based on that. Please see attached excel sheet for a sample. 

4 Replies
Solution

Hi,

 

You need to SUMIFS function!

So, I've updated the workbook with this formula:

=SUMIFS(Data!$C$2:$C$510,Data!$B$2:$B$510,A5,Data!$A$2:$A$510,$A$2)

 

But please note that there are some duplicate numbers in Sheet1 / New Account Number column.

 

Hope that helps

It worked, thanks so much!
Please, kindly teach me how to use those excel formula for calculation.
Thanks

Hi @PromiseO1245,

 

Please check out the resources below that could be helpful to learn how to start using SUMIF/SUMIFS functions:

SUMIF

SUMIFS

 

Hope that helps

 

 

 

Related Conversations
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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies