As a start, the ranges should be the same size:

SUMIF(A$93:$117, A93, p$55:p$84)

Those ranges aren't the same size.

A93:A117 = 25 cells
P55:P84 = 30 cells

So, using:

=SUMIF(A$93:A$117,A93,P$55:P$84)

Cells P80:P84 are not being included in the calculation.

--
Biff
Microsoft Excel MVP


"PetroBP" wrote in message
...
I am trying to use SUMIF. In columncells a93:a117 I have names that are the
"range" In column p55:p84 I have the Sum-range of values to be added.
For
the criteria i used each name in a93:a117. So my first sumif says,
SUMIF(A$93:$117, A93, p$55:p$84). All that seem sto be happening is that
the
values in column P are just getting copied in order, with no attachment to
the range names and nu summation. What am I doing wrong? I even tried
putting the "criiteria" in quotes, so (A$93:$117, "Bob", p$55:p$84). It
still does not work. can anyone help?