Copy formulas from rows & columns

P

PERANISH

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
 
M

muddan madhu

Below formula is not working for me,

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

Marcelo

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:
 
P

PERANISH

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

-peranish
 
M

Marcelo

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



"PERANISH" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
move data to another file 0
SUMPRODUCT troubles 2
Copy text into blank rows 2
HIGHLIGHTING DULPICATES WITH TWO COLUMNS & DELETING DUPLICATE 0
Lookup Formula 4
To criteria with Reference from Cell 3
Format column widths from one table to a separate table on same page 1

Top