| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| Skip columns and copy formulas | Excel Discussion (Misc queries) | |||
| Copy Formulas when inserting rows | Excel Discussion (Misc queries) | |||
| copy formulas to cells absolute rows and variable columns | Excel Discussion (Misc queries) | |||
| Copy/Insert rows with formulas | Excel Worksheet Functions | |||
Hybrid Mode
