software

I am stuck. I am trying to use the quot;SUMIFquot; function in conjunjunction
with quot;NAMEquot; references and a combo box. For example, I have groups of
cells aligned in columns that are named. I have a combo box that I
created using 'cell validation' containing the months. An example of
the formula I am trying to get to work is as follows:

=SUMIF(COSTCENTER,A11,MAR)

COSTCENTER is a group of cells that have a defined name as well as
MAR.
The combo box displays 'TEXT' and I want it to be referenceing the NAME
instead.

Can anyone help? If you need to see the excel spreadsheet to
understand, I can send.--
sseavert
------------------------------------------------------------------------
sseavert's Profile: www.excelforum.com/member.php...oamp;userid=33579
View this thread: www.excelforum.com/showthread...hreadid=533566
If I read you correctly, then

=SUMIF(CostCentre,A11,INDIRECT($A$12))

where A12 contains the selected Month, which is a named range, will
work.

--

sseavert Wrote:
gt; I am stuck. I am trying to use the quot;SUMIFquot; function in conjunjunction
gt; with quot;NAMEquot; references and a combo box. For example, I have groups of
gt; cells aligned in columns that are named. I have a combo box that I
gt; created using 'cell validation' containing the months. An example of
gt; the formula I am trying to get to work is as follows:
gt;
gt; =SUMIF(COSTCENTER,A11,MAR)
gt;
gt; COSTCENTER is a group of cells that have a defined name as well as
gt; MAR.
gt; The combo box displays 'TEXT' and I want it to be referenceing the NAME
gt; instead.
gt;
gt; Can anyone help? If you need to see the excel spreadsheet to
gt; understand, I can send.--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533566
Yes... This worked. Thank you for your help.--
sseavert
------------------------------------------------------------------------
sseavert's Profile: www.excelforum.com/member.php...oamp;userid=33579
View this thread: www.excelforum.com/showthread...hreadid=533566
Good to see, and thanks for your response

--

sseavert Wrote:
gt;
gt;
gt; Yes... This worked. Thank you for your help.
gt;
gt; gt; Bryan Hessey Wrote:
gt; gt; If I read you correctly, then
gt; gt;
gt; gt; =SUMIF(CostCentre,A11,INDIRECT($A$12))
gt; gt;
gt; gt; where A12 contains the selected Month, which is a named range, will
gt; gt; work.
gt; gt;
gt; gt; --gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533566