One way:
=SUMIF(A:A,"Joe",B:B)
if you want to do this for all of your salesmen, this is a perfect
application for a Pivot Table:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
In article ,
JeffDamin wrote:
i have a spreadsheet that lists by salesman po's and their value. how do i
create a formula so that i can add all the rows just for a particular
salesman. i do have the drop down list on the salesman header.