see response to your 16:29 post about column L


--
Regards

Roger Govier


"Mark Allen" wrote in message
...
Hi Roger, are you still there ??

Have you any more suggestions ??

Mark

"Roger Govier" wrote:

Hi Mark

Try it as
=SUMPRODUCT(--(Data!$C$1:$C$10000=$A$3),--(Data!$L$1:$L$10000=A19))

Does that make any difference?

--
Regards

Roger Govier


"Mark Allen" wrote in message
...
Roger please see answers below:

"Roger Govier" wrote:

Hi Mark

What do you have on Sheet Data in cell A3 and A19?
**A3 and A19 are on the calculation sheet S Wright. This is where I
start
the equation from

Are they numbers or text? Are the numbers true numbers or Text
numbers
** There is both numbers and text. ie. A3=Suzanne Wright and
A19=CPS900

compared with the data in the relevant columns.
Does the Text have any leading or trailing spaces.
** NO

--
Regards

Roger Govier


"Mark Allen" <Mark wrote in
message
...
I am trying to re-create a spreadsheet into a single file where
previously I
was linking to another but I am now having problems.

Original code:
=SUMPRODUCT(('No Prospects.xls'!$D$1:$D$10000=$A$3)*('No
Prospects.xls'!$G$1:$G$10000=A19))

Returns a value of 2

New code:
=SUMPRODUCT((Data!$C$1:$C$10000=$A$3)*(Data!$L$1:$ L$10000=A19))

Returns a value of 0 !!!!! should be 2

I know the cell range has changed i.e. D to C and G to L but
this
should not
matter.

Please help as this is really frustrating !!!!

Mark