Combo Box using Name Ref
 

I am stuck. I am trying to use the "SUMIF" function in conjunjunction
with "NAME" 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: http://www.excelforum.com/member.php...o&userid=33579
View this thread: http://www.excelforum.com/showthread...hreadid=533566

Combo Box using Name Ref
 

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:
I am stuck. I am trying to use the "SUMIF" function in conjunjunction
with "NAME" 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.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533566

Combo Box using Name Ref
 

Yes... This worked. Thank you for your help.


--
sseavert
------------------------------------------------------------------------
sseavert's Profile: http://www.excelforum.com/member.php...o&userid=33579
View this thread: http://www.excelforum.com/showthread...hreadid=533566

Combo Box using Name Ref
 

Good to see, and thanks for your response

--

sseavert Wrote:


Yes... This worked. Thank you for your help.

Bryan Hessey Wrote:
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.

--


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533566