| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
COUNTIF for multiple sheets
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| COUNTIF across multiple sheets with unknown names | Excel Worksheet Functions | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| COUNTIF across multiple sheets | Excel Worksheet Functions | |||
| CountIF across multiple sheets in a workbook | Excel Worksheet Functions | |||
Threaded Mode
