Forum Discussion
ctd162
Sep 17, 2021Copper Contributor
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 a...
- Sep 17, 2021
ctd162 That could be something like:
=SUMIF(D4:D100,"313",H4:H100)
Adjust the ranges to whatever you real schedule requires.
Riny_van_Eekelen
Sep 17, 2021Platinum Contributor
ctd162 That could be something like:
=SUMIF(D4:D100,"313",H4:H100)
Adjust the ranges to whatever you real schedule requires.
ctd162
Sep 17, 2021Copper Contributor
Riny_van_EekelenThank you! That is so much simpler than what I was finding!