Countif formula

Closed
Report
Posts
2
Registration date
Sunday January 9, 2011
Status
Member
Last seen
January 10, 2011
-
 RayH -
Hello all,

I have a sheet named Mon, and currently my formula is
=Countif(Mon!5:31,A4)

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

=COUNTIF($5:$31,A4)
Is this what you mean?