How do I write a code that gives me the average from region 1 to 6? I have to us

Question

How do I write a code that gives me the average from region 1 to 6?

I have to use a userform

022 Month Region 1 Region 2 Region 3 Region 4 Region 5 Region 6 2 Jan-08 144770 111200 163140 118110 105010 167350 3 Feb-08 155180 155100 129850 133940 140880 104110 4 Mar-08 86230 162310 142950 131490 150160 158720 5 Apr-08 148800 165160 123840 141050 175870 108100 6 May-08 157140 130300 114990 128220 147790 167470 Jun-08 126150 163240 149360 152240 167320 181070 Jul-08 174010 183360 122120 149730 134220 135530 9 Aug-08 171780 130050 124130 134510 175590 122230 10 Sep-08 126260 162690 123960 128260 172570 121300 11 Oct-08 150250 150070 97140 165670 111570 159440 12 Nov-08 180720 146370 122200 148150 106310 124800 13 Dec-08 130140 167210 179220 116150 193620 124550 14 Jan-09 145900 124890 97160 139640 156140 180100 15 Feb-09 123470 127730 159030 148450 158130 117560 16 Mar-09 120950 149830 127550 204700 161240 156710 17 Apr-09 121230 99890 161110 129310 129360 145430 18 May-09 162040 126700 116130 170520 128640 114600 19 Jun-09 126400 97370 123920 157750 136300 152650 20 Jul-09 118190 138890 119970 114250 186550 168920 21 Aug-09 166300 145580 162230 63600 120780 184450 22 Sep-09 166560 130490 103500 145670 154860 123710 23 Oct-09 148960 136850 118180 110110 177690 156210 24 Nov-09 91190 92010 155190 137780 169620 158870 25 Dec-09 89010 131940 146640 152590 135710 102260 26 Jan-10 122120 91370 130400 125400 151260 140260 27 Feb-10 124010 145210 170340 153470 139890 188440 28 Mar-10 145090 151980 148890 136040 155250 133160 29 Apr-10 123080 74000 171960 141340 127950 110320 30 May-10 147250 171630 165220 138150 124560 155770 31 Jun-10 124320 148410 162310 186440 147200 146200 32 Jul-10 135100 131520 151780 153920 121200 141430 33 Aug-10 150790 151970 168800 144170 140360 139990 34 Sep-10 93740 168100 142040 126440 113500 130500 35 Oct-10 124160 148560 120190 155600 132590 155510 36 Nov-10 109840 189790 127460 135160 149470 163330 37 Dec-10 127100 108640 145300 127920 151130 122900 2 7 2 1 2 3 1 2

Explanation / Answer

= AVERAGE(B2:C37)

Directly use this formula in excel ( Verified in spreadsheet. Should work in excel too.)

Do give a thumbs up :)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.