View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Looking for a better solution

On Tue, 4 Nov 2008 13:20:26 -0800 (PST), Spiky wrote:

Weird. It's there for me. Also 5.06, downloaded sometime this last
spring, IIRC. I tried it quick and it works. I put this on 2 sheets:
Start
Start
Stop
Stop
Start
Stop
Stop
Stop
Start

=COUNTIF.3D(Sheet1:Sheet2!A1:A9,"Stop")
Returns "10".

I don't know what to tell you. Corrupted download?


Well, I will try again.
--ron