Tennisguuy
Well-known Member
- Joined
- Oct 17, 2007
- Messages
- 564
- Office Version
- 2016
- Platform
- Windows
I'm trying to sum a range of sales where the values I want to sum are in the same column and based on different criteria and I also need to based the argument on another column. For example in column A I have a list of sales and I want to sum the sales if the sales are greater than 0 but less than 5,000,000 and if the name in column B is equal to say John.
Column A Column B
500,000 John
1,000,000 Steve
15,000,000 John
3,000,000 John
In this example the answer would be 3,500,000
Column A Column B
500,000 John
1,000,000 Steve
15,000,000 John
3,000,000 John
In this example the answer would be 3,500,000