| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct error | Excel Worksheet Functions | |||
| Sumproduct DIV/0 Error | Excel Worksheet Functions | |||
| Sumproduct error | Excel Discussion (Misc queries) | |||
| SUMPRODUCT with #VALUE error | Excel Worksheet Functions | |||
| sumproduct error | Excel Programming | |||
Linear Mode
