Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am trying to use a SUMIF funtion in which the "sum_range" is defined
as a named range of cells. If I include the range name in the formula everything is fine. However, I want to have the range name in a cell then refernece the "sum_range" portion of the SUMIF formula to the cell that contains the range anem. Does not appear to work. Any advice would be appreciated. |
#2
![]() |
|||
|
|||
![]()
With the range name in A1:
=SUMIF(INDIRECT(A1),"X") Tim C "Oscar" wrote in message oups.com... I am trying to use a SUMIF funtion in which the "sum_range" is defined as a named range of cells. If I include the range name in the formula everything is fine. However, I want to have the range name in a cell then refernece the "sum_range" portion of the SUMIF formula to the cell that contains the range anem. Does not appear to work. Any advice would be appreciated. |
#3
![]() |
|||
|
|||
![]()
Oscar,
Here is an example =SUMIF(INDIRECT(C1),"ABC",INDIRECT(D1)) where C1 might hold A1:A10 or a range name, as would D1. -- HTH RP (remove nothere from the email address if mailing direct) "Oscar" wrote in message oups.com... I am trying to use a SUMIF funtion in which the "sum_range" is defined as a named range of cells. If I include the range name in the formula everything is fine. However, I want to have the range name in a cell then refernece the "sum_range" portion of the SUMIF formula to the cell that contains the range anem. Does not appear to work. Any advice would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Passing a range name as an argument to the Index Function | Excel Discussion (Misc queries) | |||
help with "criterea" in the sumif function | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
how do you do a sumif function on more than one worksheet? | Excel Worksheet Functions | |||
SUMIF across a range of worksheets | Excel Worksheet Functions |