Sumif?

[CHC Consulting LLC]

Row 103 = Categories (ENGINEERING, FIELDING, TCP, LAYOUT, OCALC)
Row 104 = Dollar Amounts

Cell T 104 = How do I sum the dollar amounts from Row 104 for that have ENGINEERING above it in Row 103?

 

[andiemac]

Maybe I'm not understanding the question completely, because your question sounds like you already know the answer you are looking for. If the following doesn't meet your needs please provide more information about what you are trying to accomplish.

=SUMIF(A103:S103,"ENGINEERING",A104:S104)

 

[markmzz]

Or try 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 /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">103</td><td style="font-weight: bold;background-color: #D8D8D8;;">ENGINEERING</td><td style="font-weight: bold;background-color: #D8D8D8;;">TCP</td><td style="font-weight: bold;text-align: center;background-color: #C5D9F1;;">ENGINEERING</td><td style="font-weight: bold;text-align: center;background-color: #C5D9F1;;">TCP</td><td style="font-weight: bold;text-align: center;background-color: #C5D9F1;;"> OCALC</td><td style="font-weight: bold;text-align: center;background-color: #C5D9F1;;">FIELDING</td><td style="font-weight: bold;text-align: center;background-color: #C5D9F1;;">LAYOUT</td></tr><tr ><td style="color: #161120;text-align: center;">104</td><td style="text-align: right;;"> $ 4,511 </td><td style="text-align: right;;"> $ 3,885 </td><td style="text-align: right;;"> $ 21,682 </td><td style="text-align: right;;"> $ 15,122 </td><td style="text-align: right;;"> $ 14,576 </td><td style="text-align: right;;"> $ 15,358 </td><td style="text-align: right;;"> $ 35,394 </td></tr><tr ><td style="color: #161120;text-align: center;">105</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><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">106</td><td style=";">*************</td><td style=";">*************</td><td style=";">*************</td><td style=";">*************</td><td style=";">*************</td><td style=";">*************</td><td style=";">*************</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">Sheet2</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">T104</th><td style="text-align:left">=SUMPRODUCT(<font color="Blue">--(<font color="Red">$A103:$S103=T103</font>),(<font color="Red">$A104:$S104</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
Markmzz