SUMIF-how do i get it to work using names in range?help

[PetroBP]

I am trying to use SUMIF. In columncells a93:a117 I have names that are the
"range" In column p5584 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$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$84). It
still does not work. can anyone help?

 

[T. Valko]

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

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

Those ranges aren't the same size.

A93:A117 = 25 cells
P5584 = 30 cells

So, using:

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

Cells P8084 are not being included in the calculation.

 

[Garrym]

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

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

 

[T. Valko]

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.