using countif and trying to search the whole workbook.

[matthew72128]

I'm trying to use COUNTIF to count the number of times a certain string of text appears in a work book. In a way it would even count new work sheets added later. Right now I'm using the "Find All" from the Edit menu. I'm using Excel 2003. It may just be some sort of syntax error. What I have now is =COUNTIF("'STARTSHEET:ENDSHEET'!","[TEXTFOUND]") and I would add new worksheets in between "startsheet" and "endsheet"

[daddylonglegs]

You can't use COUNTIF function with 3D references [ i.e. multiple worksheets].

One way would be to download Morefunc add-in and use COUNTIF.3D function

Note: that's the usual link I use for Morefunc but when I checked just now I got some sort of error....you may be able to access Morefunc from elsewhere, try googling...

[martindwilson]

well you could try this but t takes a bit of time setting up
array formula in a2 on each sheet counts all instances of word "apple" in specified range on that sheet (i used a3:k21 and coloured it yelow for clarity)
sheet1 a1 simply totals the results. but youd have to copy the formula/paste special values and re confirm with ctrl+shift+enter for each new work sheet and also extend formula in a1 to include new sheet.
i suspect there's a nice bit of vba code somewhere that'll do it easier

[shg]

that's the usual link I use for Morefunc but when I checked just now I got some sort of error ...

Try http://www.brothersoft.com/morefunc-...oad-11046.html

[vane0326]

Hope this helps!