Sumif will not work on like this, use:

=sumif($aa$100:$aa$1000,"ad",$ab$100:$ab$1000)

Another way is:

=sumproduct(--($aa$100:$aa$1000="AD"),($ab$100:$ab$1000))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"PERANISH" escreveu:

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