Countif formula

Registration date
Sunday January 9, 2011
Last seen
January 10, 2011
 RayH -
Hello all,

I have a sheet named Mon, and currently my formula is

The range of cells i want to count from are rows 5 to 31 (with unlimited columns - because I will be constantly adding data in).

Now on another sheet, i have those countif formulas but i need to manually correct the range of 5:31 every time ( i dragged the corner downwards and it only automatically corrected the cell (criteria) of the current sheet i.e. A4, A5, A6, A7.

Is there any macro codes or any other way to let it automatically fill all 28 rows with the CountIf formula with the range of 5:31 (on the Mon spreadsheet)?

I have 7 sheets that needs these formulas.. and each sheet as a total of 28 rows :( manually correcting each cell will be a nightmare!

Any help is appreciated!

1 reply

Is this what you mean?