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
Bookmarks