Countifs with ranges from different docs
Irina Iatco
✭✭
Hi,
I have this formula: =COUNTIF({Smartsheet - Master Data - National (Atten Range 1}, [Email Address]1)
I would like to add an additional range from a different doc to look at the same thing - email address.
Do I use the countifs and just add the 2nd range right after the first one ? Thank you!!
Answers
-
CountIfs are used to add extra filters to your selection. I would just add two together (or at least that is what I do).
-
Yeah what @Javier Arbelaez stated.
=COUNTIF({Sheet1/Range1}, [Email Address]1)+COUNTIF({Sheet2/Range1}, [Email Address]1)
-
Thank you so much!
-
@John Jonassen Thank you so much for including the exact formula!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives