Hey all,

I've got a "Master" sheet and an "Archive" sheet. I'm needing to count how many times I use a title from the "Master" sheet. In other words, I select any number of titles and then archive that list in the "Archive" sheet. So I need a formula to count how many times the title from the "Master" sheet is shown on the "Archive" sheet.

I've tried: =COUNTIF(ARCHIVE!B:B,Master!B2) but that returns a 0.

Thanks for your help,

Keyrookie