I need help with creating a formula.

i have 2 columns in my data i need to sum in my chart, 1 column is the sales
reps name the other column is staus. when a project i work on becomes an
order i type the word "order" in the status column, but i cant get the 2
columns to add up in my chart.
what im trying to do is every time a given sales reps name appears in one
column and the word "order" appears in the other column in the same row.
i need to have a sum of how many times this appears, this gives me the
amount of orders any one sales rep has generated.

any help would be greatly appreciated, i would be glad to forward my spread
sheet to any one that would like to look it over and help me out.

John Watson