porter2059
New Member
- Joined
- Apr 5, 2018
- Messages
- 6
is there a way to embed an "and statement" inside a sumif statement so that it sumifs based on the combination of 2 criteria? or is there a better way to do it?
A | B | C | D | E | I | J | K | ||||||
1 | Amount | town | Memo | Net | Direct | ||||||||
2 | 1 | Town A | Direct | Town A | |||||||||
3 | 2 | Town B | Net | Town B | |||||||||
4 | 3 | Town A | Net | ||||||||||
5 | 4 | Town B | Direct | ||||||||||
6 | 5 | Town A | Direct | ||||||||||
7 | |||||||||||||
8 | |||||||||||||
9 | |||||||||||||
10 |