Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sumproduct...
i'm having data in two pages and my criteria page is third one...i've used
Sum product to get the data with multiple criteria..now what the problem is..in data pages the product code is starting with "0511652" etc.,. starting with "0" so it is showing in text and i required "0" starting for the product is must...i require the formula that has to convert text to number or the procedure...after converting the product code into number...with that criteria i want to get the data from the rest of two data sheets.....i hope u have understand my problem..can any one help???? Thanks in advance.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sumproduct...
Hello,
Put a double unary minus before your text expression - this will enforce a transformation into a number: --A1 will result in 3 if A1 contains a text like "003". Regards, Bernd |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sumproduct...
i'm unable to follow u...pls explain me clearly
"Bernd P" wrote: Hello, Put a double unary minus before your text expression - this will enforce a transformation into a number: --A1 will result in 3 if A1 contains a text like "003". Regards, Bernd |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with Sumproduct...
Hello,
Please give an explicite example of which data you have and what you would like to get. Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct #Value! Problem | Excel Worksheet Functions | |||
SUMPRODUCT problem | Excel Discussion (Misc queries) | |||
SUMPRODUCT Problem | New Users to Excel | |||
Problem with SumProduct | Excel Discussion (Misc queries) | |||
Another Sumproduct & #N/A problem | Excel Worksheet Functions |