detriez
Board Regular
- Joined
- Sep 13, 2011
- Messages
- 193
- Office Version
- 365
- Platform
- Windows
These two formulas work independently but I cant figure out how to put them together
I'm trying to count the status values AND Countries
I tried this but, the counts are wrong
I'm trying to count the status values AND Countries
Code:
=SUM(COUNTIFS(Table6[Lead Status],{"Open","Suspect","Working - Attempted","Working - Connected"}))
Code:
=SUM(COUNTIFS(Table6[Country],{"United States","Canada"}))I tried this but, the counts are wrong
Code:
=COUNTIFS(Table6[Lead Status],{"Open","Suspect","Working - Attempted","Working - Connected"},Table6[Country],{"United States","Canada"})
