How to lock selected cells when the protect sheet feature is turned on?
Can anyone help? Below is a basic way to find rows that match 3 criteria, work out the average to each column G to M of all the rows that match the criteria and copy and past to a repot sheet.
Basically I have 2 columns the first column has years in it & the second has random letters. Now, going down the 1st column it reads: 2007,2007,2007,2007,2007,2008,2008,2008,2009,2009,2009,2009 And going down the Second Column it reads: A,B,A,B,B,B,A,B,A,A,A,B Note: This is just a segment of the data table. What i need is formula that will answer the [...]
What formula will appear in cell C7 if the formula =B6*$B$1 is copied from cell C6 to C7?





