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.