Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am in search of formula
Dear Sir,
Price per Each Nos a b c d b a c f d 1 2 5 6 5 9 7 8 6 8 6 7 2 3 4 8 6 5 a 41 b 69 c 91 d 46 I want a formula which will search "a" in block " Price per each" and in "Nos" and then automatically sumproduct the said column and will give result such as "41". Similarly "b"- 69, "c"-91, "d"-46. Kakoli |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am in search of formula
Why does b=69, is that a typo?
"kakolisarkar" wrote: Dear Sir, Price per Each Nos a b c d b a c f d 1 2 5 6 5 9 7 8 6 8 6 7 2 3 4 8 6 5 a 41 b 69 c 91 d 46 I want a formula which will search "a" in block " Price per each" and in "Nos" and then automatically sumproduct the said column and will give result such as "41". Similarly "b"- 69, "c"-91, "d"-46. Kakoli |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am in search of formula
Please don't multipost.
http://www.cs.tut.fi/~jkorpela/usenet/xpost.html -- David Biddulph "kakolisarkar" wrote in message ... Dear Sir, Price per Each Nos a b c d b a c f d 1 2 5 6 5 9 7 8 6 8 6 7 2 3 4 8 6 5 a 41 b 69 c 91 d 46 I want a formula which will search "a" in block " Price per each" and in "Nos" and then automatically sumproduct the said column and will give result such as "41". Similarly "b"- 69, "c"-91, "d"-46. Kakoli |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I am in search of formula
Mike
Thank you for your response. b= 69 is typing mistake it will be 28 kakoli "Mike H" wrote: Why does b=69, is that a typo? "kakolisarkar" wrote: Dear Sir, Price per Each Nos a b c d b a c f d 1 2 5 6 5 9 7 8 6 8 6 7 2 3 4 8 6 5 a 41 b 69 c 91 d 46 I want a formula which will search "a" in block " Price per each" and in "Nos" and then automatically sumproduct the said column and will give result such as "41". Similarly "b"- 69, "c"-91, "d"-46. Kakoli |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SEARCH FORMULA | Excel Discussion (Misc queries) | |||
need help with a search formula | Excel Discussion (Misc queries) | |||
another formula search, if any | Excel Discussion (Misc queries) | |||
Search formula | Excel Worksheet Functions | |||
Search within formula | Excel Worksheet Functions |