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 that possible?
Thx in advance,
2 Replies
Sort By
- Riny_van_EekelenPlatinum 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.
- Willem1310Copper ContributorThx Riny