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
|