Thread
:
Problem with formula/doesn't pull data with slash (/)
View Single Post
#
2
Posted to microsoft.public.excel.misc
paul
external usenet poster
Posts: 247
Problem with formula/doesn't pull data with slash (/)
what are you actually trying to acheive?
--
paul
remove nospam for email addy!
"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.
Reply With Quote
paul
View Public Profile
Find all posts by paul