SOLVED

Find instances in one column and add all from another column

%3CLINGO-SUB%20id%3D%22lingo-sub-2761053%22%20slang%3D%22en-US%22%3EFind%20instances%20in%20one%20column%20and%20add%20all%20from%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2761053%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20be%20able%20to%20add%20up%20all%20the%20numbers%20from%20one%20column%20that%20are%20associated%20with%20a%20code%20in%20another%20column.%20So%2C%20from%20the%20sheet%20below%2C%20for%20example%2C%20I%20would%20like%20the%20formula%20to%20be%20able%20to%20identify%20all%20of%20the%20practice%20code%20313%20items%20(which%20are%20in%20text%20format)%20by%20using%20column%20D%2C%20and%20then%20find%20and%20add%20up%20all%20of%20the%20financial%20assistance%20numbers%20associated%20with%20that%20code%20that%20are%20found%20in%20column%20H.%20Let%20me%20know%20if%20I%20need%20to%20clarify%20further.I%20am%20using%20Excel%20on%20my%20Mac.%20I%20would%20appreciate%20any%20tips.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202021-09-17%20at%2012.06.32%20PM.png%22%20style%3D%22width%3A%20785px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F311138i8C3F3E07F24A0634%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screen%20Shot%202021-09-17%20at%2012.06.32%20PM.png%22%20alt%3D%22Screen%20Shot%202021-09-17%20at%2012.06.32%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2761053%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2761073%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20instances%20in%20one%20column%20and%20add%20all%20from%20another%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2761073%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1159116%22%20target%3D%22_blank%22%3E%40ctd162%3C%2FA%3E%26nbsp%3BThat%20could%20be%20something%20like%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DSUMIF(D4%3AD100%2C%22313%22%2CH4%3AH100)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EAdjust%20the%20ranges%20to%20whatever%20you%20%26nbsp%3Breal%20schedule%20requires.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello!

 

I would like to be able to add up all the numbers from one column that are associated with a code in another column. So, from the sheet below, for example, I would like the formula to be able to identify all of the practice code 313 items (which are in text format) by using column D, and then find and add up all of the financial assistance numbers associated with that code that are found in column H. Let me know if I need to clarify further.I am using Excel on my Mac. I would appreciate any tips. 

Screen Shot 2021-09-17 at 12.06.32 PM.png

2 Replies
best response confirmed by ctd162 (New Contributor)
Solution

@ctd162 That could be something like:

=SUMIF(D4:D100,"313",H4:H100)

Adjust the ranges to whatever you  real schedule requires. 

@Riny_van_EekelenThank you! That is so much simpler than what I was finding!