Finding nearby cells with offsetsSometimes you want to calculate things based upon cells close by to the cell you are providing a calculation in.OFFSET() retrieves the values in cells offset from the current location by a certain number of rows and columns. It takes two arguments: the number of rows down to move from the current location, and the number of columns to move right.You can also specify height and width arguments to return a range of cells, which is often useful in combination with a summary statistic function like SUM(), AVERAGE() or MAX().InstructionsIn cell I1, get the count of Skippers in the Indian Subcontinent as the value from the cell offset 1 down from C1.In cell I2, again get the count of Skippers in the Indian Subcontinent, this time as the value from the cell offset 2 right from A2.In cell I3, get the count of Skippers in Western Himalaya as the values from the range of cells offset 2 right from A3, with height 7, and sum them.Please show the all formula in excel thank you :) AreaLocalitySkipperSwallowtailWhite-yellowBlueBrush-footedC1, offset 1 column down Indian SubcontinentIndian Subcontinent3079499458482A2, offset 2 columns right Western HimalayaWestern Himalaya633142129152A3, offset 2 columns right, height 7, summed Western HimalayaKangra Hills2523375687 Western HimalayaShimla Hills41213488115 Western HimalayaDehradun Valley2211194254 Western HimalayaMussoorie Hills54233288126 Western HimalayaMussoorie Town1410134465 Western HimalayaKumaon Hills522637109147 Central HimalayaCentral Himalaya1254349185221 North East India + North MyanmarNorth East India + North Myanmar2116957284342 North East India + North MyanmarNorth East India1896252258292 North East India + North MyanmarSikkim1595551162263 North East India + North MyanmarDarjeeling27293248126 North East India + North MyanmarNaga Hills673830110178 North East India + North MyanmarManipur11918112657 North East India + North MyanmarKhasia Hills984236128207 North East India + North MyanmarKhasia + Jaintia Hills1324940166209 North East India + North MyanmarMizoram Hills59132677101 Other parts of IndiaKolkata3210195749 Other parts of IndiaSouth Bihar189124639 Other parts of IndiaNorth Bihar1910233861 Other parts of IndiaLucknow157193335 Other parts of IndiaDehli114202220 Other parts of IndiaMhow124293134 Other parts of IndiaJodhpur146212017 Other parts of IndiaKathiawar115192221 Other parts of IndiaNorth Gujarat45181715 Other parts of IndiaSouth Gujarat2210254642 Other parts of IndiaPune1910504144 Other parts of IndiaKonkan2311193542 Other parts of IndiaKarwar5416216666 Other parts of IndiaCoorg6018318089 Other parts of IndiaBangalore209255036 Other parts of IndiaTravancore3715265884 Other parts of IndiaPalani Hills4615308375 Other parts of IndiaNilgiri Hills6423358290 Other parts of IndiaEastern Ghats2312213130 Other parts of IndiaSikanderabad75142024 Other parts of IndiaAndaman Nikobar4213206874 Sri LankaSri Lanka4815298268 North MyanmarChindwin District65242681124 North MyanmarArakan coast2115214260 North MyanmarShan States2816256495

Question

Finding nearby cells with offsetsSometimes you want to calculate things based upon cells close by to the cell you are providing a calculation in.OFFSET() retrieves the values in cells offset from the current location by a certain number of rows and columns. It takes two arguments: the number of rows down to move from the current location, and the number of columns to move right.You can also specify height and width arguments to return a range of cells, which is often useful in combination with a summary statistic function like SUM(), AVERAGE() or MAX().InstructionsIn cell I1, get the count of Skippers in the Indian Subcontinent as the value from the cell offset 1 down from C1.In cell I2, again get the count of Skippers in the Indian Subcontinent, this time as the value from the cell offset 2 right from A2.In cell I3, get the count of Skippers in Western Himalaya as the values from the range of cells offset 2 right from A3, with height 7, and sum them.Please show the all formula in excel thank you :) AreaLocalitySkipperSwallowtailWhite-yellowBlueBrush-footedC1, offset 1 column down Indian SubcontinentIndian Subcontinent3079499458482A2, offset 2 columns right Western HimalayaWestern Himalaya633142129152A3, offset 2 columns right, height 7, summed Western HimalayaKangra Hills2523375687  Western HimalayaShimla Hills41213488115  Western HimalayaDehradun Valley2211194254  Western HimalayaMussoorie Hills54233288126  Western HimalayaMussoorie Town1410134465  Western HimalayaKumaon Hills522637109147  Central HimalayaCentral Himalaya1254349185221  North East India + North MyanmarNorth East India + North Myanmar2116957284342  North East India + North MyanmarNorth East India1896252258292  North East India + North MyanmarSikkim1595551162263  North East India + North MyanmarDarjeeling27293248126  North East India + North MyanmarNaga Hills673830110178  North East India + North MyanmarManipur11918112657  North East India + North MyanmarKhasia Hills984236128207  North East India + North MyanmarKhasia + Jaintia Hills1324940166209  North East India + North MyanmarMizoram Hills59132677101  Other parts of IndiaKolkata3210195749  Other parts of IndiaSouth Bihar189124639  Other parts of IndiaNorth Bihar1910233861  Other parts of IndiaLucknow157193335  Other parts of IndiaDehli114202220  Other parts of IndiaMhow124293134  Other parts of IndiaJodhpur146212017  Other parts of IndiaKathiawar115192221  Other parts of IndiaNorth Gujarat45181715  Other parts of IndiaSouth Gujarat2210254642  Other parts of IndiaPune1910504144  Other parts of IndiaKonkan2311193542  Other parts of IndiaKarwar5416216666  Other parts of IndiaCoorg6018318089  Other parts of IndiaBangalore209255036  Other parts of IndiaTravancore3715265884  Other parts of IndiaPalani Hills4615308375  Other parts of IndiaNilgiri Hills6423358290  Other parts of IndiaEastern Ghats2312213130  Other parts of IndiaSikanderabad75142024  Other parts of IndiaAndaman Nikobar4213206874  Sri LankaSri Lanka4815298268  North MyanmarChindwin District65242681124  North MyanmarArakan coast2115214260  North MyanmarShan States2816256495

Accepted Answer

Find the answers below.

Area	Locality	Skipper	Swallowtail	White-yellow	Blue	Brush-footed	C1, offset 1 column down
Indian Subcontinent	Indian Subcontinent	307	94	99	458	482	A2, offset 2 columns right
Western Himalaya	Western Himalaya	63	31	42	129	152	A3, offset 2 columns right, height 7, summed
Western Himalaya	Kangra Hills	25	23	37	56	87
Western Himalaya	Shimla Hills	41	21	34	88	115
Western Himalaya	Dehradun Valley	22	11	19	42	54
Western Himalaya	Mussoorie Hills	54	23	32	88	126
Western Himalaya	Mussoorie Town	14	10	13	44	65
Western Himalaya	Kumaon Hills	52	26	37	109	147
Central Himalaya	Central Himalaya	125	43	49	185	221
North East India + North Myanmar	North East India + North Myanmar	211	69	57	284	342
North East India + North Myanmar	North East India	189	62	52	258	292
North East India + North Myanmar	Sikkim	159	55	51	162	263
North East India + North Myanmar	Darjeeling	27	29	32	48	126
North East India + North Myanmar	Naga Hills	67	38	30	110	178
North East India + North Myanmar	Manipur	119	18	1	126	57
North East India + North Myanmar	Khasia Hills	98	42	36	128	207
North East India + North Myanmar	Khasia + Jaintia Hills	132	49	40	166	209
North East India + North Myanmar	Mizoram Hills	59	13	26	77	101
Other parts of India	Kolkata	32	10	19	57	49
Other parts of India	South Bihar	18	9	12	46	39
Other parts of India	North Bihar	19	10	23	38	61
Other parts of India	Lucknow	15	7	19	33	35
Other parts of India	Dehli	11	4	20	22	20
Other parts of India	Mhow	12	4	29	31	34
Other parts of India	Jodhpur	14	6	21	20	17
Other parts of India	Kathiawar	11	5	19	22	21
Other parts of India	North Gujarat	4	5	18	17	15
Other parts of India	South Gujarat	22	10	25	46	42
Other parts of India	Pune	19	10	50	41	44
Other parts of India	Konkan	23	11	19	35	42
Other parts of India	Karwar	54	16	21	66	66
Other parts of India	Coorg	60	18	31	80	89
Other parts of India	Bangalore	20	9	25	50	36
Other parts of India	Travancore	37	15	26	58	84
Other parts of India	Palani Hills	46	15	30	83	75
Other parts of India	Nilgiri Hills	64	23	35	82	90
Other parts of India	Eastern Ghats	23	12	21	31	30
Other parts of India	Sikanderabad	7	5	14	20	24
Other parts of India	Andaman Nikobar	42	13	20	68	74
Sri Lanka	Sri Lanka	48	15	29	82	68
North Myanmar	Chindwin District	65	24	26	81	124
North Myanmar	Arakan coast	21	15	21	42	60
North Myanmar	Shan States	28	16	25	64	95