<div>
you can use following formula<br />
for example if you have value starting in B2 and end value cell is B50<br />
<br />
=SUM(B2:B50)
</div>


you can use following formula
for example if you have value starting in B2 and end value cell is B50

=SUM(B2:B50)

<div>
I'm sorry but I'm not understanding the anwsers. &nbsp;I've attached a simple file with example. &nbsp;I want D3 to be the sum of the values C6 through C10 which have the adjacent cell in row B equal to Employee
</div>


I'm sorry but I'm not understanding the anwsers.  I've attached a simple file with example.  I want D3 to be the sum of the values C6 through C10 which have the adjacent cell in row B equal to Employee

<div>
Can you try attaching again? I don't see an attachment in your question nor your comment.
</div>


Can you try attaching again? I don't see an attachment in your question nor your comment.

<div>
Bingo, &nbsp;your example worked for me teylyn. &nbsp;Thanks!
</div>


Bingo,  your example worked for me teylyn.  Thanks!

<div>
<div class="content wysiwyg-content">
Row A has text entries of; Employee, Contractor, Temp<br />
Row B has a number (cost)<br />
<br />
I want to sum all the values in Row B that have an adjacent Row A value of &quot;Employee&quot;
</div>
</div>


Row A has text entries of; Employee, Contractor, Temp
Row B has a number (cost)

I want to sum all the values in Row B that have an adjacent Row A value of "Employee"

Excel 2010 - sum a row of values based on an adjacent cell's value

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.