SUMIF - really simple, but beats me - help!

K

KDD

Hi, Can someone tell me how to add values from cells in 1 column from a
database where only those cells are picked for summation basis a given
criteria (e.g. a name) which i specify. Needless to say, the "name" is also
there in the same database.
 
K

KDD

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
 
D

Dave Peterson

There are a couple of common problems.

Names not spelled the same in the formula as in the table (extra spaces is a
common problem).

The numbers in the cells look like numbers, but they're really text.

If you use a couple of helper cells and put these formulas in them:

=count(b1:b10)
and
=counta(b1:b10)

Adjust the range to match the real addresses.

If they don't match, you can select an empty cell.
edit|copy
select the cells of "numbers"
edit|paste special|check add

=======
But it sounds like you could use a pivottable for this (once you clean your
data!) that would make it easier.

To read more about the pivottable stuff, you may want to look at some links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistance/2002/articles/xlconPT101.aspx
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
Click to expand...
 
J

JE McGimpsey

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.
 
Top