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