hello all,
i am using following sumproduct formula ang facing this error #value !
=SUMPRODUCT((CashBook!$J$24:$J$15098=PL!$C6)*(Cash Book!$P$24:$P$15098))
coulmns "P" contaning formula as under:
Col_N Col_O Col_P
9,00 114.14 1,090,000.

thanks in advance

Looks like there is a #VALUE in the data being analysed.

--
__________________________________
HTH

Bob

"Tufail" wrote in message
...
hello all,
i am using following sumproduct formula ang facing this error #value !
=SUMPRODUCT((CashBook!$J$24:$J$15098=PL!$C6)*(Cash Book!$P$24:$P$15098))
coulmns "P" contaning formula as under:
Col_N Col_O Col_P
9,00 114.14 1,090,000.

thanks in advance

tnx for posting, if i change col_N insted col_P which don't have formula then
there isn't any error coming out, so i think that's problam with carrying
formula, is there any salutation ?

"Bob Phillips" wrote:

Looks like there is a #VALUE in the data being analysed.

--
__________________________________
HTH

Bob

"Tufail" wrote in message
...
hello all,
i am using following sumproduct formula ang facing this error #value !
=SUMPRODUCT((CashBook!$J$24:$J$15098=PL!$C6)*(Cash Book!$P$24:$P$15098))
coulmns "P" contaning formula as under:
Col_N Col_O Col_P
9,00 114.14 1,090,000.

thanks in advance

What do you mean by carrying formula?

--
__________________________________
HTH

Bob

"Tufail" wrote in message
...
tnx for posting, if i change col_N insted col_P which don't have formula
then
there isn't any error coming out, so i think that's problam with carrying
formula, is there any salutation ?

"Bob Phillips" wrote:

Looks like there is a #VALUE in the data being analysed.

--
__________________________________
HTH

Bob

"Tufail" wrote in message
...
hello all,
i am using following sumproduct formula ang facing this error #value !
=SUMPRODUCT((CashBook!$J$24:$J$15098=PL!$C6)*(Cash Book!$P$24:$P$15098))
coulmns "P" contaning formula as under:
Col_N Col_O Col_P
9,00 114.14 1,090,000.

thanks in advance

i means range $P$24:$P$15098 have this formula
=IF(AND($M24="USD",ISNUMBER($N24+$O24)),$N24*$O24, IF($M24="JPY",$N24,""))
if i change my range like $N$24:$N$15098 <-- my this range don't have any
formula, in this case there is not any error, so i think this is due to
contaning formula in col_P, hope you understand now and would help me on this
error.

=SUMPRODUCT((CashBook!$J$24:$J$15098=PL!$C6)*(Cash Book!$P$24:$P$15098))

Col_N(no any formula) Col_O(exchange rate) Col_P (above formula)
9,00 114.14 1,090,000.



"Bob Phillips" wrote:

What do you mean by carrying formula?

--
__________________________________
HTH

Bob

"Tufail" wrote in message
...
tnx for posting, if i change col_N insted col_P which don't have formula
then
there isn't any error coming out, so i think that's problam with carrying
formula, is there any salutation ?

"Bob Phillips" wrote:

Looks like there is a #VALUE in the data being analysed.

--
__________________________________
HTH

Bob

"Tufail" wrote in message
...
hello all,
i am using following sumproduct formula ang facing this error #value !
=SUMPRODUCT((CashBook!$J$24:$J$15098=PL!$C6)*(Cash Book!$P$24:$P$15098))
coulmns "P" contaning formula as under:
Col_N Col_O Col_P
9,00 114.14 1,090,000.

thanks in advance

I have knocked up a simple example using your formulae, and it works fine
for me. I still think it is a data error.

--
__________________________________
HTH

Bob

"Tufail" wrote in message
...
i means range $P$24:$P$15098 have this formula
=IF(AND($M24="USD",ISNUMBER($N24+$O24)),$N24*$O24, IF($M24="JPY",$N24,""))
if i change my range like $N$24:$N$15098 <-- my this range don't have any
formula, in this case there is not any error, so i think this is due to
contaning formula in col_P, hope you understand now and would help me on
this
error.

=SUMPRODUCT((CashBook!$J$24:$J$15098=PL!$C6)*(Cash Book!$P$24:$P$15098))

Col_N(no any formula) Col_O(exchange rate) Col_P (above formula)
9,00 114.14
1,090,000.



"Bob Phillips" wrote:

What do you mean by carrying formula?

--
__________________________________
HTH

Bob

"Tufail" wrote in message
...
tnx for posting, if i change col_N insted col_P which don't have
formula
then
there isn't any error coming out, so i think that's problam with
carrying
formula, is there any salutation ?

"Bob Phillips" wrote:

Looks like there is a #VALUE in the data being analysed.

--
__________________________________
HTH

Bob

"Tufail" wrote in message
...
hello all,
i am using following sumproduct formula ang facing this error #value
!
=SUMPRODUCT((CashBook!$J$24:$J$15098=PL!$C6)*(Cash Book!$P$24:$P$15098))
coulmns "P" contaning formula as under:
Col_N Col_O Col_P
9,00 114.14 1,090,000.

thanks in advance