sum of item. containting different words

[faizee]

<TABLE style="WIDTH: 159pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=211><COLGROUP><COL style="WIDTH: 94pt; mso-width-source: userset; mso-width-alt: 4571" width=125><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><TBODY><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #4f81bd; WIDTH: 94pt; HEIGHT: 15.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=21 width=125>products</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #4f81bd; WIDTH: 65pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl66 width=86>amount</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #b8cce4; HEIGHT: 15.75pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl69 height=21>box 2</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl67 align=right>15000</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl70 height=20>hardboad final</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl68 align=right>12950</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #b8cce4; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl69 height=20>paper 9</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl67 align=right>22400</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl70 height=20>paper 234</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl68 align=right>25400</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #b8cce4; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl69 height=20>knife ws</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl67 align=right>59200</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl70 height=20>box 99</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl68 align=right>10300</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #b8cce4; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl69 height=20>box small</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl67 align=right>75100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl70 height=20>paper</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl68 align=right>52100</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #b8cce4; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl69 height=20>knife</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl67 align=right>10500</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl70 height=20>pin shart</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl68 align=right>50400</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #b8cce4; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl69 height=20>pin sharp</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl67 align=right>10500</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl70 height=20>pad</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl68 align=right>20000</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #b8cce4; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl69 height=20>box big</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl67 align=right>26200</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: white 0.5pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl70 height=20>knife</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: white 0.5pt solid" class=xl68 align=right>15750</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8; mso-ignore: colspan" height=20 colSpan=2>I want to sum amount of all those products who have following words in their name</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>1. box</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>2. knife</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20>3. hardboard</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR></TBODY></TABLE>

 

[faizee]

no, its getting result "0"

 

[Aladin Akyurek]

no, its getting result "0"

What formula?

 

[faizee]

Let A1:C15 house the data, E2:E4 items box, hardbord, and knife, and F2 May-09.

Try...

=SUMPRODUCT(
    --ISNUMBER(MATCH($A$2:$A$15,E2:E4,0)),
    --($C$2:$C$15=F2),
    $B$2:$B$15)

=SUMPRODUCT(--ISNUMBER(MATCH($A$2:$A$15,E2:E4,0)),--($C$2:$C$15=F2),$B$2:$B$15)

I tried this formula, but its not working, its giving only '0' value

 

[Aladin Akyurek]

=SUMPRODUCT(--ISNUMBER(MATCH($A$2:$A$15,E2:E4,0)),--($C$2:$C$15=F2),$B$2:$B$15)

I tried this formula, but its not working, its giving only '0' value

Select C2, go to the Formula Bar, copy what you see, and paste it here.

Select F2, go to the Formula Bar, copy what you see, and paste it here.

 

[faizee]

i feel really stupid,
but i didnt understand it.

Can you help me in detail?

 

[Aladin Akyurek]

i feel really stupid,
but i didnt understand it.

Can you help me in detail?

What did you not understand? The instructions in the last post?

 

[ravi4ever]

Hi Faiz, this is quite simple to implement than what you think off, ask somebody who is good at Excel around you to update the solution provided by us in your spreadsheet.