Hi All

I am trying to use the COUNTIF function to return the number of times a name appears in a range of data that is entered by day and total that number by week. I can get that to work as =+(COUNTIF(Sheet1!C$5:I$57,$A4) but i want to report the same info for the next week range of 7 days which is J$5:P$57 in the next column along, when i drag the formula it automatically chooses the range of D$5:J$57. I've tried manually entering two columns to see if Excel learns and drags across accordingly but it doesn't. Any Ideas?