Return Text in an IF formula

[Guest]

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

 

[Don Guillett]

SUM

 

[vezerid]

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

 

[Guest]

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

 

[Guest]

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