Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return Text in an IF formula
Please can anyone help?
I have an If formula set up to extract info from one worksheet to another when a certain value is entered. basically the data is in columns of our code, their code and description. the formula for the numeric columns is fine and returns the correct data however the formula to return the description text only returns a 0. can anyone see what i have wrong in the formula? =SUMIF('Oct 07-Sept 08'!A5:A108,Sheet1!A8:A37,'Oct 07-Sept 08'!B5:B108) Kind regards Jamie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return Text in an IF formula
SUM
-- Don Guillett Microsoft MVP Excel SalesAid Software "Jamie76" wrote in message ... Please can anyone help? I have an If formula set up to extract info from one worksheet to another when a certain value is entered. basically the data is in columns of our code, their code and description. the formula for the numeric columns is fine and returns the correct data however the formula to return the description text only returns a 0. can anyone see what i have wrong in the formula? =SUMIF('Oct 07-Sept 08'!A5:A108,Sheet1!A8:A37,'Oct 07-Sept 08'!B5:B108) Kind regards Jamie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return Text in an IF formula
Jamie,
SUMIF will ignore text. Also, take note that typically SUMIF expects a single value in its 2nd argument. Instead you are supplying a range of cells Sheet1!A8:A37. Also, SUMIF adds several numbers that match the criterion. What would be your corresponding intention for multiple text values matching the criterion? My guess is you intend a lookup operation. Something like: =VLOOKUP(Sheet1!A8,'Oct 07-Sept 08'!A5:B108,2,0) HTH Kostis Vezerides On Oct 11, 6:02 pm, Jamie76 wrote: Please can anyone help? I have an If formula set up to extract info from one worksheet to another when a certain value is entered. basically the data is in columns of our code, their code and description. the formula for the numeric columns is fine and returns the correct data however the formula to return the description text only returns a 0. can anyone see what i have wrong in the formula? =SUMIF('Oct 07-Sept 08'!A5:A108,Sheet1!A8:A37,'Oct 07-Sept 08'!B5:B108) Kind regards Jamie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return Text in an IF formula
Thanks Dom but now it just comes up with #VALUE!
=IF('Oct 07-Sept 08'!A5:A108,Sheet1!A8:A37,'Oct 07-Sept 08'!B5:B108) could it be anything else? Jamie "Don Guillett" wrote: SUM -- Don Guillett Microsoft MVP Excel SalesAid Software "Jamie76" wrote in message ... Please can anyone help? I have an If formula set up to extract info from one worksheet to another when a certain value is entered. basically the data is in columns of our code, their code and description. the formula for the numeric columns is fine and returns the correct data however the formula to return the description text only returns a 0. can anyone see what i have wrong in the formula? =SUMIF('Oct 07-Sept 08'!A5:A108,Sheet1!A8:A37,'Oct 07-Sept 08'!B5:B108) Kind regards Jamie |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return Text in an IF formula
Thanks Dom but now it just comes up with #VALUE!
=IF('Oct 07-Sept 08'!A5:A108,Sheet1!A8:A37,'Oct 07-Sept 08'!B5:B108) could it be anything else? Do i just have the total wrong formula? Jamie "Don Guillett" wrote: SUM -- Don Guillett Microsoft MVP Excel SalesAid Software "Jamie76" wrote in message ... Please can anyone help? I have an If formula set up to extract info from one worksheet to another when a certain value is entered. basically the data is in columns of our code, their code and description. the formula for the numeric columns is fine and returns the correct data however the formula to return the description text only returns a 0. can anyone see what i have wrong in the formula? =SUMIF('Oct 07-Sept 08'!A5:A108,Sheet1!A8:A37,'Oct 07-Sept 08'!B5:B108) Kind regards Jamie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to return part of a text string | Excel Discussion (Misc queries) | |||
Return formula as text | Excel Worksheet Functions | |||
Link to text and return text into a formula? | Excel Worksheet Functions | |||
Return a text string when the result of VLOOKUP formula is #N/A | Excel Worksheet Functions | |||
Return a formula as text string to a cell | Excel Worksheet Functions |