Remember Me?

#1
 Oscar Posts: n/a
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function

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.

#2
 Tim C Posts: n/a

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.

#3
 Bob Phillips Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Michael Sharpe Excel Discussion (Misc queries) 3 September 5th 12 01:33 PM [email protected] Excel Worksheet Functions 3 December 17th 04 07:27 PM JaneC Excel Worksheet Functions 4 December 10th 04 01:25 AM BMWPRO Excel Worksheet Functions 1 December 6th 04 09:26 PM Mike@Q Excel Worksheet Functions 3 November 24th 04 03:36 PM

All times are GMT +1. The time now is 07:52 AM.