I have been combing the forums for an answer but feel there may be an easier way to solve my problem without learning arrays, etc. (hopefully!). I have some data on one sheet and I am trying to represent the sum of data on another sheet. I realize for one instance of summing I could complete by writing "=SUM(data!B3:B4)." However, if I want the cell below the previous one to indicate "=SUM(data!B5:B6)." Here is where I run into my dilemma. When I drag for formula down to populate the column it doesn't skip what has been summed already and would provide =SUM(data!B4:B5), then =SUM(data!B5:B6), etc. How does the logic change for including the sum of three or four at a time without the same overlapping problem when the formula is dragged down? Any help would be appreciated; many thanks.
Bookmarks