Below formula is not working for me,

to unchange the cell references use $ (symbol) - $AA$100:$AB$1000



On May 26, 5:23*pm, PERANISH
wrote:
*i having many columns having different formulas. i want to coy all formulas
to next many rows of all columns.

example

* * * *col-A * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* COL - B
1 * * =SUMIF((AA100:AA1000="AD"),(AB100:AB1000)) *
=COUNTIF(AA100:AA1000="AD",1,0)

IF I COPY FROM ROW 1 TO 2, RANGES CHANGED TO AA101:AA1001.
BUT I WANT SAME TO BE COPY TO THE BELOW ROWS.

REQUEST YOUR HELP PLEASE.
-PERANISH