Combo Box using Name Ref

[sseavert]

I am stuck. I am trying to use the "SUMIF" function in conjunjunctio
with "NAME" references and a combo box. For example, I have groups o
cells aligned in columns that are named. I have a combo box that
created using 'cell validation' containing the months. An example o
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 a
MAR.
The combo box displays 'TEXT' and I want it to be referenceing the NAM
instead.

Can anyone help? If you need to see the excel spreadsheet t
understand, I can send

 

[Bryan Hessey]

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]

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

 

[Bryan Hessey]

Good to see, and thanks for your response

--

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