Using Subtotal, group (sort) the records on city and find the total price for each city. Enter the At each change in: value in Blank 1, the Use function: value in Blank 2 and the Add subtotal to: value in Blank 3 (see below for sample Subtotal input box). Subtotal ale changer se function Add totalto Blank # 1 AY Blank # 2 Blank # 3 AM zip A B street city 1092 MAUGHAM CT RIVERTON 5201 BLOSSOM RANCH DR CODY 9760 LAZULITE CT CODY 2981 WRINGER DR RAWLINS 7849 BONNY DOWNS WAY CODY 8442 KEUSMAN ST CODY 9264 BOULDER RIVER WAY CODY 8373 BLACKMAN WAY CODY 8935 MOUNTAIN HOME CT CODY 1 3305 RIO ROCA CT CHEYENNE 2 9297 TROUT WAY CODY 3 4804 NORIKER DR CODY 14 8636 TEGEA WAY CODY 15 4240 WINJE DR CHEYENNE 16 5529 LAGUNA PARK DR CODY 17 11826 DIONYSUS WAY LANDER 18 10372 VIA CINTA CT CODY 19 294 SPARROW DR RIVERTON 20 9720 LITTLE HARBOR WAY CODY 21 4636 TEAL BAY CT CHEYENNE Wyoming Rural Real Estate Sales C D E F G H state price beds baths sq ft home size 95632 WY $3,36,000 5 4 3746 Very Large 95757 WY $3,60,000 4 4 4303 Very Large 95624 WY $3,68,000 4 3 3992 Very Large 95661 WY $4,90,721 4 3 3838 Very Large 95758 WY $1,63,934 4 2 2306 Standard 95758 WY $1,71,000 4 2 2329 Standard 95624 WY $1,78,200 5 2 2254 Standard 95624 WY $1,78,446 5 3 2136 Standard 95624 WY $ 1,86,800 4 2 2111 Standard 95843 WY $1,91,760 4 3 2652 Standard 95624 WY $1,92,000 4 2 2367 Standard 95757 WY $ 1,94,110 3 2 2163 Standard 95624 WY $1,96,734 5 3 2508 Standard 95843 WY $1,97,400 2 2504 Standard 95758 WY $2,06,400 5 2790 Standard 95742 WY $2,12,800 4 2 2711 Standard 95757 WY $ 2.19,540 4 3 2724 Standard 95632 WY $2,22.400 3 2214 Standard 95624 WY $2,24,000 4 3 2494 Standard 95843 WY $2,32,000 4 2 2160 Standard latitude longitude type 38.271646 -121.286848 Residential 38.399436 -121.444041 Residential 38.403609 -121.335541 Residential 38.735373 121.227072 Residential 38.42139 -121.411339 Residential 38.449651 -121.414704 Residential 38.421713 -121.345191 Residential 38.435436 -121.394536 Residential 38.38751 -121.370276 Residential 38.725079 -121.387698 Residential 38.420637 - 121.375798 Residential 38.400974 - 121.448424 Residential 38.443832 -121.382087 Residential 38.70884 -121.359559 Residential 38.42568 -121.438062 Residential 38.551045-121.239411 Residential 38.380089-121.428186 Residential 38.258976 - 121.321266 Residential 38.404934 - 121.352405 Residential 38.704554 121.354753 Residential