Excel
It should work if you just copy and paste it. Or select the range of your working area and right click in destination cell and choose paste special. When new window pop up, just choose Formula.
It should work usually, but by any chance you've encountered the problem regarding this. Just let me know...i'll try to help you...
P.S.: If this information was helpful, please rate this solution.
The copy paste idea should work if the "configuration/size" of your working area is similar.
Let me show you the analogy:
When you copy paste the formula from AA45 to AA100, the formula will be (=COUNTIF(H77:H104,1)) automatically.Your Working Area (where are the value to be counted) are H22 to H155.
Your put the formula (=COUNTIF(H22:H49,1)) in cell AA45.
Can you see "the working area size" that i mean? Can you get the idea?
If you want to put the formula (=COUNTIF(H133:H155,1)) by copying paste it, you can't do that automatically because the working area is not similar (the size is not equal).
The first working area are : H22 to H49 which equal to 28 rows, and in the second formula it will be from H133 to H155 which equal to 23 rows.
But, if the formula could be changed to (=COUNTIF(H133:H158,1)) which is equal to 28 rows of working area, you can try to copy paste the initial formula (=COUNTIF(H22:H49,1) to cell AA156.
Like that the "configuration/size" of working area will be similar.
I will fully understand if you have difficulity to understand what i'm trying to say (i'm not an influence english speaker nor writer :)). Sorry for my poor english, just do not hesitate to ask for more if you still need my help.
P.S.: If this information was helpful, please rate this solution.
×
167 views
Usually answered in minutes!
As I said Amateur here
Lets say COUNTIF(H22:49,"1") is on Row 45 Column AA and I want to move this formula to COUNTIF(H133:H155,"!") Row 100 Column AA.
The cut and paste works but it still counts my first area when I paste it
×