SUMPRODUCT #value! error
 

hi
alot of time i use this SUMPRODUCT formula without any problem, but this
time i don't know somehow this error is coming out, even i checked formula
100 times but just don't know why #value! error is coming out, so plz someone
can help me.

=SUMPRODUCT(('Sold list'!$L$7:$L$3000='List room'!G4)*('Sold
list'!$K$7:$K$3000))

error is coming for = 'List room'!G4
i hope you can understand i have two sheets 1=Sold list and 2=List room.
if you want to know any more detail so plz just let me know.
thanks in advance.

tufail

SUMPRODUCT #value! error
 

is there a #Value! error in your data?

--
Regards,
Tom Ogilvy

"Tufail" wrote in message
...
hi
alot of time i use this SUMPRODUCT formula without any problem, but this
time i don't know somehow this error is coming out, even i checked formula
100 times but just don't know why #value! error is coming out, so plz
someone
can help me.

=SUMPRODUCT(('Sold list'!$L$7:$L$3000='List room'!G4)*('Sold
list'!$K$7:$K$3000))

error is coming for = 'List room'!G4
i hope you can understand i have two sheets 1=Sold list and 2=List room.
if you want to know any more detail so plz just let me know.
thanks in advance.

tufail

SUMPRODUCT #value! error
 

no i don't think so, how can i check ? coz i already check many many times.

"Tom Ogilvy" wrote:

is there a #Value! error in your data?

--
Regards,
Tom Ogilvy

"Tufail" wrote in message
...
hi
alot of time i use this SUMPRODUCT formula without any problem, but this
time i don't know somehow this error is coming out, even i checked formula
100 times but just don't know why #value! error is coming out, so plz
someone
can help me.

=SUMPRODUCT(('Sold list'!$L$7:$L$3000='List room'!G4)*('Sold
list'!$K$7:$K$3000))

error is coming for = 'List room'!G4
i hope you can understand i have two sheets 1=Sold list and 2=List room.
if you want to know any more detail so plz just let me know.
thanks in advance.

tufail

SUMPRODUCT #value! error
 

select the columns in Sold List and do
Edit=Go to = Special, select formulas and uncheck all but errors, then
click OK.

if it is successful, then see what is selected.

--
Regards,
Tom Ogilvy

"Tufail" wrote in message
...
no i don't think so, how can i check ? coz i already check many many
times.

"Tom Ogilvy" wrote:

is there a #Value! error in your data?

--
Regards,
Tom Ogilvy

"Tufail" wrote in message
...
hi
alot of time i use this SUMPRODUCT formula without any problem, but
this
time i don't know somehow this error is coming out, even i checked
formula
100 times but just don't know why #value! error is coming out, so plz
someone
can help me.

=SUMPRODUCT(('Sold list'!$L$7:$L$3000='List room'!G4)*('Sold
list'!$K$7:$K$3000))

error is coming for = 'List room'!G4
i hope you can understand i have two sheets 1=Sold list and 2=List
room.
if you want to know any more detail so plz just let me know.
thanks in advance.

tufail

SUMPRODUCT #value! error
 

Look for non-numeric values (just plain old text) in K7:k3000, too.

Tufail wrote:

no i don't think so, how can i check ? coz i already check many many times.

"Tom Ogilvy" wrote:

is there a #Value! error in your data?

--
Regards,
Tom Ogilvy

"Tufail" wrote in message
...
hi
alot of time i use this SUMPRODUCT formula without any problem, but this
time i don't know somehow this error is coming out, even i checked formula
100 times but just don't know why #value! error is coming out, so plz
someone
can help me.

=SUMPRODUCT(('Sold list'!$L$7:$L$3000='List room'!G4)*('Sold
list'!$K$7:$K$3000))

error is coming for = 'List room'!G4
i hope you can understand i have two sheets 1=Sold list and 2=List room.
if you want to know any more detail so plz just let me know.
thanks in advance.

tufail




--

Dave Peterson

SUMPRODUCT #value! error
 

thanks but sorry there isn't any changing, is there any other way to check it
out ?


"Dave Peterson" wrote:

Look for non-numeric values (just plain old text) in K7:k3000, too.

Tufail wrote:

no i don't think so, how can i check ? coz i already check many many times.

"Tom Ogilvy" wrote:

is there a #Value! error in your data?

--
Regards,
Tom Ogilvy

"Tufail" wrote in message
...
hi
alot of time i use this SUMPRODUCT formula without any problem, but this
time i don't know somehow this error is coming out, even i checked formula
100 times but just don't know why #value! error is coming out, so plz
someone
can help me.

=SUMPRODUCT(('Sold list'!$L$7:$L$3000='List room'!G4)*('Sold
list'!$K$7:$K$3000))

error is coming for = 'List room'!G4
i hope you can understand i have two sheets 1=Sold list and 2=List room.
if you want to know any more detail so plz just let me know.
thanks in advance.

tufail




--

Dave Peterson

SUMPRODUCT #value! error
 

Dear Tom Ogilvy,
Thank you very much for your help but sorry to say nothing any happend even
i did many times when i am going back and saw all check marked are there.


"Tom Ogilvy" wrote:

select the columns in Sold List and do
Edit=Go to = Special, select formulas and uncheck all but errors, then
click OK.

if it is successful, then see what is selected.

--
Regards,
Tom Ogilvy

"Tufail" wrote in message
...
no i don't think so, how can i check ? coz i already check many many
times.

"Tom Ogilvy" wrote:

is there a #Value! error in your data?

--
Regards,
Tom Ogilvy

"Tufail" wrote in message
...
hi
alot of time i use this SUMPRODUCT formula without any problem, but
this
time i don't know somehow this error is coming out, even i checked
formula
100 times but just don't know why #value! error is coming out, so plz
someone
can help me.

=SUMPRODUCT(('Sold list'!$L$7:$L$3000='List room'!G4)*('Sold
list'!$K$7:$K$3000))

error is coming for = 'List room'!G4
i hope you can understand i have two sheets 1=Sold list and 2=List
room.
if you want to know any more detail so plz just let me know.
thanks in advance.

tufail

SUMPRODUCT #value! error
 

Select K7:K3000 on "Sold List".

Edit|goto|special
Select Constants
uncheck everything but Text

If you don't find anything, do the same thing, but look in formulas:
Edit|goto|special
Select Formulas
uncheck everything but Text

Remember you have to look in hidden rows, too (if you're just scanning the
data).

Tufail wrote:

thanks but sorry there isn't any changing, is there any other way to check it
out ?

"Dave Peterson" wrote:

Look for non-numeric values (just plain old text) in K7:k3000, too.

Tufail wrote:

no i don't think so, how can i check ? coz i already check many many times.

"Tom Ogilvy" wrote:

is there a #Value! error in your data?

--
Regards,
Tom Ogilvy

"Tufail" wrote in message
...
hi
alot of time i use this SUMPRODUCT formula without any problem, but this
time i don't know somehow this error is coming out, even i checked formula
100 times but just don't know why #value! error is coming out, so plz
someone
can help me.

=SUMPRODUCT(('Sold list'!$L$7:$L$3000='List room'!G4)*('Sold
list'!$K$7:$K$3000))

error is coming for = 'List room'!G4
i hope you can understand i have two sheets 1=Sold list and 2=List room.
if you want to know any more detail so plz just let me know.
thanks in advance.

tufail




--

Dave Peterson


--

Dave Peterson