products amount
box 2 15000
hardboad final 12950
paper 9 22400
paper 234 25400
knife ws 59200
box 99 10300
box small 75100
paper 52100
knife 10500
pin shart 50400
pin sharp 10500
pad 20000
box big 26200
knife 15750
table 2 table 3
box pin
knife scale
hardboard pencil
total: total:
(answer 225000)
sum amount cell containing table 2 sum amount cell containing table 3
productsamountbox 215000hardboad final12950paper 922400paper 23425400knife ws59200box 9910300box small75100paper52100knife10500pin shart50400pin sharp10500pad20000box big26200knife15750table 2table 3boxpinknifescalehardboardpenciltotal:total:(answer 225000)sum amount cell containing table 2sum amount cell containing table 3
Can't tell from this post whether all of this is in a single cell and how it is broken up. Please post your example in a spreadsheet (Go Advanced> Manage Attachments)
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Hi, hoping to have understood. The formula has to be confirmed with control+shift+enter
=SUM(IF(NOT(VAL.ERROR(SEARCH({"box","knife","hardboad"},A2:A1000))),B2:B1000))
Peace
Last edited by CANAPONE; 05-27-2010 at 11:01 AM.
Assuming your data is in A2:B15 and Table 2 is in E3:E5, this will work;
=SUMPRODUCT(--(ISNUMBER(FIND(E3,$A$2:$A$15)))+(ISNUMBER(FIND(E4,$A$2:$A$15)))+(ISNUMBER(FIND(E5,$A$2:$A$15))),$B$2 :$B$15)
Does that meet your needs?
ChemistB
My 2¢
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks