The data section called Transaction Growth shows how many boxed sets were sold each month. Keith entered a formula into the range O6:O10 to calculate the highest amount of each set sold over the course of the year. He notices that all of the values in the range are 1,408, even though more boxed sets than this were sold in some months. Edit the formula in cell O6 so that it uses relative references instead of absolute references for the range B6:M6, and then copy the formula from cell O6 to fill the range O7:O10 without formatting.
I cant figure out how in the world to change it to make the formula do what I want. I just blasted through Word, PowerPoint, Access and the first 2 parts of Excel in 30 hours, so maybe my brain is fried. any help is wanted!