Countifs with ranges from different docs

Irina Iatco · 09/08/20

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!!

Javier Arbelaez · 09/08/20

CountIfs are used to add extra filters to your selection. I would just add two together (or at least that is what I do).

John Jonassen · 09/08/20

Yeah what @Javier Arbelaez stated.

=COUNTIF({Sheet1/Range1}, [Email Address]1)+COUNTIF({Sheet2/Range1}, [Email Address]1)

Irina Iatco · 09/08/20

Thank you so much!

Irina Iatco · 09/08/20

@John Jonassen Thank you so much for including the exact formula!

Answers