Posted to microsoft.public.excel.misc

Ross

Posts: n/a

Returning #Value! in Cell

Hello,

I am using the below formula:

=SUMPRODUCT((SUBSTITUTE(A1:A10,"P","")="N001")*(B1 :B10=--"02/06/06")*(C1:C10))

but am getting #VALUE! returned in the cell as I am trying to return Text
not numbers from the Column C cells. Does anyone know a way round this so I
can return the text?

Thanks,
Ross

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
looking for another same value cell in a range and returning a coresponding value	dawid72	Excel Worksheet Functions	4	June 9th 06 08:35 PM
Custom functions calculating time arguments Help Desperate	Bill_De	Excel Worksheet Functions	12	April 25th 06 02:22 AM
Returning Cell Comments from One Cell to Another	RJS	Excel Worksheet Functions	3	March 13th 06 11:39 PM
Returning a cell's formula in a different cell	T.R. Young	Excel Worksheet Functions	2	February 16th 06 06:41 PM
Returning active cell	Ted Metro	Excel Worksheet Functions	2	May 3rd 05 02:47 PM

All times are GMT +1. The time now is 10:01 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us