=SUMIF (SUM) will ignore the data with / as it treats it as non-numeric.

Do you actual want to SUM these numbers or return them as a string?

Given (only) the three cells below, what do you want returned?

8400
8500/8550
8400/8500/8550


"Greg" wrote:

Hi,

I was wondering whether someone could give me a hand with this formula,
or whats wrong with this formula:

=sumif('Parts&Product Numbers'!D$3:D$500,Stock!A32,'Parts&Product
numbers'!E$3:E$500)

The formula works, but it doesnt pull the information i want in column
e (at the end of the formula). In column E i have three variables:

8400
8500/8550
8400/8500/8550

the formula only returns the 8400 variable, it doesn't seem to like the
/ , or any other form of punctuation. Please could someone tell me how
it can return these variables with their attached /.

thank you

Greg.