Can SUMPRODUCT be used with IF?

[Demetious]

Here is my formula, needless to say, it doesn't work. Anyone know why?

=SUMPRODUCT(IF(A25:A34="Jack",A36,0),(IF(C25:C34="Jack",C36,0)))

Thanks!

 

[Scott Huish]

What are you trying to accomplish exactly?

However, this is my guess:

=SUMPRODUCT((A25:A34="Jack")*A36,(C25:C34="Jack")*C36)

 

[markmzz]

Here is my formula, needless to say, it doesn't work. Anyone know why?

=SUMPRODUCT(IF(A25:A34="Jack",A36,0),(IF(C25:C34="Jack",C36,0)))

Thanks!

I used your array formula and it worked. Look at this:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: center;background-color: #FFFF00;;">Result</td><td style="text-align: center;background-color: #FFFF00;;">200</td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: center;background-color: #C5D9F1;;">Jack</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">Jack</td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: center;background-color: #C5D9F1;;">Jack</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">Jack</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="text-align: center;background-color: #C5D9F1;;">Jack</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">Jack</td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">Jack</td></tr><tr ><td style="color: #161120;text-align: center;">35</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">36</td><td style="text-align: center;background-color: #C5D9F1;;">10</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">20</td></tr><tr ><td style="color: #161120;text-align: center;">37</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td></tr><tr ><td style="color: #161120;text-align: center;">38</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet5</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B23</th><td style="text-align:left">{=SUMPRODUCT(<font color="Blue">IF(<font color="Red">A25:A34="Jack",A36,0</font>),(<font color="Red">IF(<font color="Green">C25:C34="Jack",C36,0</font>)</font>)</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />
Did you press Ctrl+Shift+Enter?

Markmzz

 

[Demetious]

I did not press Ctrl + Shift + Enter. Thanks!

 

[Scott Huish]

My solution does not need CTRL-SHIFT-ENTER and does the same thing.

 

[Demetious]

Bah, that didn't work. I misrepresented what I was trying to do. Here is an example of my table. The column data is at A25:A34, C25:C34, E25:E34

<TABLE style="WIDTH: 372pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=492><COLGROUP><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" span=6 width=82><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; WIDTH: 124pt; HEIGHT: 15pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl76 height=20 width=164 colSpan=2>Sale 1</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 124pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl76 width=164 colSpan=2>Sale 2</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 124pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: black 1pt solid" class=xl76 width=164 colSpan=2>Sale 3</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 1pt solid" class=xl78 height=20 colSpan=2>Seller Name</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 1pt solid" class=xl78 colSpan=2>Seller Name</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: black 1pt solid" class=xl78 colSpan=2>Seller Name</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 height=20 colSpan=2>Jack</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2>Bill</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2>Roy</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 height=20 colSpan=2>Jon</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2>George</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2>Aaron</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 height=20 colSpan=2>Bob</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2>Joe</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2>Neil</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 height=20 colSpan=2>Roger</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2>Jack</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 height=20 colSpan=2>Tom</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 height=20 colSpan=2></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 height=20 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 height=20 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72 height=20 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73 colSpan=2> </TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #d8d8d8; HEIGHT: 15.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74 height=21 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 colSpan=2> </TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl75 colSpan=2> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl81 height=20 colSpan=2>Amount Per Seller</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 colSpan=2>Amount Per Seller</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl80 colSpan=2>Amount Per Seller</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl82 height=21 colSpan=2>$46.83</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83 colSpan=2>$281.00</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl83 colSpan=2>$56.20</TD></TR></TBODY></TABLE>

If Jack's name is present in any given column, as in column 1 and column 3, I want to add the amount per seller, eg., $46.83 and $56.20. Thanks again for any help.

 

[Scott Huish]

=(COUNTIF(A25:A34,"Jack")*A36)+(COUNTIF(C25:C34,"Jack")*C36)

 

[markmzz]

Try this with SUMPRODUCT function:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: center;;">Sale 1</td><td style="text-align: center;;"></td><td style="text-align: center;;">Sale 2</td><td style="text-align: center;;"></td><td style="text-align: center;;">Sale 3</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: center;;">Seller Name</td><td style="text-align: center;;"></td><td style="text-align: center;;">Seller Name</td><td style="text-align: center;;"></td><td style="text-align: center;;">Seller Name</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: center;background-color: #C5D9F1;;">Jack</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">Bill</td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;">Roy</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: center;background-color: #C5D9F1;;">Jon</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">George</td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;">Aaron</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: center;background-color: #C5D9F1;;">Bob</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">Joe</td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;">Neil</td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: center;background-color: #C5D9F1;;">Roger</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;">Jack</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: center;background-color: #C5D9F1;;">Tom</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;"></td></tr><tr ><td style="color: #161120;text-align: center;">35</td><td style="text-align: center;;">Amount Per Seller</td><td style="text-align: center;;"></td><td style="text-align: center;;">Amount Per Seller</td><td style="text-align: right;;"></td><td style="text-align: center;;">Amount Per Seller</td></tr><tr ><td style="color: #161120;text-align: center;">36</td><td style="text-align: center;background-color: #C5D9F1;;">46.83</td><td style="text-align: center;;"></td><td style="text-align: center;background-color: #C5D9F1;;">281</td><td style="text-align: right;;"></td><td style="text-align: center;background-color: #C5D9F1;;">56.2</td></tr><tr ><td style="color: #161120;text-align: center;">37</td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: center;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">38</td><td style="text-align: center;background-color: #FFFF00;;">Result</td><td style="text-align: center;background-color: #FFFF00;;">103.03</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">39</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">40</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet6</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B38</th><td style="text-align:left">=SUMPRODUCT(<font color="Blue">(<font color="Red">A25:A34="Jack"</font>)*A36+(<font color="Red">C25:C34="Jack"</font>)*C36+(<font color="Red">E25:E34="Jack"</font>)*E36</font>)</td></tr></tbody></table></td></tr></table><br />
Markmzz

 

[Demetious]

Thank you both so much. I have been working at this for two days, seems so simple to see it written out now. Problem solved.

 

[markmzz]

Thank you both so much. I have been working at this for two days, seems so simple to see it written out now. Problem solved.

I'm happy that your problem was solved.

Markmzz