How do I create a formula that covers two sheets ?

Irina Iatco

Hi,

I currently have this formula in use and I'd like to include one more sheet. How do I do that? Thank you!

=COUNTIF({Master Data - National (Atten how did you hear)}, Label14)

Mark Cronk

Hi Irina,

If I'm understanding what you want to do the answer is to add additional COUNTIF statements. Along the lines of:

=COUNTIF({Master Data - National (Atten how did you hear)}, Label14) + COUNTIF({2nd sheet range}, Label14) + COUNTIF(3rd sheet range}, Label14)

Work?

Mark