onthegreen03
Board Regular
- Joined
- Jun 30, 2016
- Messages
- 148
- Office Version
- 365
- Platform
- Windows
Hi - I am trying to use the FILTER function to count the number of unique accounts by region, AND the number of those accounts with a positive sales trend. See the table below. In cells C23:C26 is where I want to return the number of UNIQUE accounts with a positive sales trend. I played around with FILTER but can't seem to figure out the right formula when you have multiple criteria. Thanks!