Hi There,
I would like to the number of cells which contain specific text. I am using =countif but the range is on a seperate sheet (tab) does anyone know what i have to do to make it look at a different sheet?
Many Thanks,
S
Hi There,
I would like to the number of cells which contain specific text. I am using =countif but the range is on a seperate sheet (tab) does anyone know what i have to do to make it look at a different sheet?
Many Thanks,
S
Just start writing your formula then click on the tab your values are in and it will reference that sheet.
BTW, I'm assuming you mean different tab within same workbook. If you mean different workbook then do the same but open the other workbook first and it will link the workbook.
Last edited by Sam Capricci; 10-05-2015 at 09:37 AM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
It worked! thank you very much!
Great! glad that worked for you and thanks for the reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks