![]() |
SUMIF-how do i get it to work using names in range?help
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-how do i get it to work using names in range?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-how do i get it to work using names in range?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? |
SUMIF-how do i get it to work using names in range?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? |
All times are GMT +1. The time now is 03:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com