Posted to microsoft.public.excel.worksheet.functions

DogLover

external usenet poster

Posts: 37

User Defined Function returning #Value!

I have a function that I created. When I test it in the Intermediate Window,
? Kountifs("Registered Nurse"), it returns a 12 which is correct.

I want to be able to use this function a my datasheet. I have included
basically the same function =Kountifs("Registered Nurse"). But, ont the
datasheet I receive a #Value! rather than the 12.

Does anyone have ideas why?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
user defined function	Pete_T	Excel Worksheet Functions	1	December 1st 07 01:03 AM
user defined function	ub	Excel Worksheet Functions	6	April 4th 07 09:42 PM
user defined function	driller	Excel Worksheet Functions	1	November 18th 06 04:51 PM
user defined function	delmac	Excel Worksheet Functions	1	August 11th 06 04:31 PM
user defined function help	Floyd Steele	Excel Worksheet Functions	1	February 2nd 06 10:47 PM

All times are GMT +1. The time now is 06:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us