Forum Discussion
Willem1310
Mar 15, 2024Copper Contributor
What kind of formula I need
I want to a formula , that looks at column F for the let's say the number 40 and add up all the amounts in column E which have the number 40, so I get a total amount of all the 40 Numbers, is t...
Riny_van_Eekelen
Mar 15, 2024Platinum Contributor
Three possible solutions in the attached file. Two formula based (SUMIF or SUMIFS). The other is a pivot table. See which one suits you best.
- Willem1310Mar 15, 2024Copper ContributorThx Riny