Copy formulas from rows & columns
 

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

Copy formulas from rows & columns
 

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

Copy formulas from rows & columns
 

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

Copy formulas from rows & columns
 

Lot of Thanks. I have wasted my time lot & now i can work in other job.
Once again thanks

-peranish

"Marcelo" wrote:

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

Copy formulas from rows & columns
 

thank you for the feedback
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"PERANISH" escreveu:

Lot of Thanks. I have wasted my time lot & now i can work in other job.
Once again thanks

-peranish

"Marcelo" wrote:

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