3D name and using Max

1) I need to create a name for a 3D reference to Sales that includes cell D18 (total of sales for the city)
2) Enter a Max function with the named range to identify the most sales (of 5 cities)

I'm not sure how to go about.

I used the SUM function when creating the 3D name reference however when entering the MAX functions it was giving me the same total...

Help!!

Hi there. it did help me and thanks for forwarding me the link. Nicely explained with easy step by step. A BIG thanks, Nathalie