1) Check that "name" is exactly what is in your table. What does

=COUNTIF(A1:A10,"name")

return?

2) Check that your amounts in B1:B10 are actually values rather than
text (e.g., verify that =ISNUMBER(B1) returns TRUE). If it is text ,
coerce it to numbers by copying a blank cell, selecting your B1:B10
values and choosing Edit/Paste Special, selecting the Values and Add
radio buttons.

In article ,
KDD wrote:

I tried that. the sum is coming as 0.

Essentially, column K has incentives made by different members of the
team,whereas column B has names of the sales executives. I want to pluck the
total incentive amount made by each executive and place it in another
worksheet under the executives name.

Column
--
KDDXB


"Dave Peterson" wrote:

Something like this???

=SUMIF(A1:A10,"name",B1:B10)