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?

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?

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

the rows in the 1st and 3rd arguements have to match for the sumif to work

"PetroBP" wrote:

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?

the rows in the 1st and 3rd arguements have
to match for the sumif to work

Technically, Excel will automatically evaluate the same number of cells for
the sum_range as is referenced in the range argument. For example:

x...1
y...1
x...1
z...1
x...1

=SUMIF(A1:A5,"x",B1)

Returns 3

There are 5 cells in the range argument so Excel will automatically evaluate
the sum_range as being 5 cells starting from cell B1.

=SUMIF(A1,"x",B1:B5)

Returns 1

There is just 1 cell in the range argument so Excel automatically evaluates
the sum_range as 1 cell, B1.

--
Biff
Microsoft Excel MVP


"Garrym" wrote in message
...
SUMIF(A$93:$117, A93, p$93:p$117)

the rows in the 1st and 3rd arguements have to match for the sumif to work

"PetroBP" wrote:

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?