how to compare range name with text

[pinstripe]

In column A
A2="R"
A3="C"
A4="D"
A5="F"
I would like to compare a range name: let say a2:a5=myrange
with the column C where i have text strings:
C1=new
C2=old
C3=myrange
C4=oldrange
In column D i have numerous different letters like in column A
In column E i have values

then: If myrange=C3 then sum all values in column E where letters in column D are equal as in column A (as myrange)

hope it is clear what i am trying to do, if not please let me know
Also, i know it is a bit complicated and if you have any other suggestion, please let me know.
thanks

[StephenR]

Not sure I quite follow but perhaps this helps?

Please Login or Register  to view this content.

[pinstripe]

hmm...
i have created rangenames with "Insert/name/define"
now i would like to include this range names (this list) or some of them in combobox ...
when name in combo is selected i get thois name in a cell (defined in properties of combo - R2)
then i would like to compare this range name -now R2 with rangenames in column C, then do the calculation i have posted in first post.
Is it possible to do something like this?