Forum Discussion

ctd162's avatar
ctd162
Copper Contributor
Sep 17, 2021
Solved

Find instances in one column and add all from another column

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. 

Excel on Mac
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 17, 2021

    ctd162 That could be something like:

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

    Adjust the ranges to whatever you  real schedule requires. 

Resources