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

  • Thread starter Thread starter PetroBP
  • Start date Start date
P

PetroBP

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)
Click to expand...

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.
 
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
 
the rows in the 1st and 3rd arguements have
to match for the sumif to work
Click to expand...

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