Enabling number of cells based on sum of two cells

[Muhammad Wasif]

Hi,
I need to enable number of cells in a column based on the sum of two cells.
Example:
If sum of A1 and A2 is 15; I need to enable 15 cells in the range B5:B100

Please advise.

Thanks

 

[AliGW]

Sorry, but what exactly do you mean by 'enable' here? If A1+A2=15, what exactly is going to happen with the range of cells mentioned?

 

[bosco_yip]

Maybe……..



In B5, enter formula and copy down to B100

=IF(ROWS($1:1)<=SUM(A$1:A$2),MAX(B$4:B4)+1,"")

Regards
Bosco

 

[Muhammad Wasif]

Sorry, but what exactly do you mean by 'enable' here? If A1+A2=15, what exactly is going to happen with the range of cells mentioned?

Hi Ali,
In my sheet i calculate total amount of required subscribers in A1 and A2. I want to restrict the input in column B to the maximum of required subscriber i.e A1+A2.
So if the total of A1+A2 is 15; in column B starting from B16, customer should only be allowed to enter until B30.

Thanks

 

[Muhammad Wasif]

Maybe……..

View attachment 43861

In B5, enter formula and copy down to B100

=IF(ROWS($1:1)<=SUM(A$1:A$2),MAX(B$4:B4)+1,"")

Regards
Bosco

Thanks Bosco
I explained the target in response to Ali's question above; but this method you suggested is also workable, if I cannot get to restrict the cells.

Thanks again.

 

[bosco_yip]

.........I want to restrict the input in column B to the maximum of required subscriber i.e A1+A2. So if the total of A1+A2 is 15; in column B starting from B16, customer should only be allowed to enter until B30.
Thanks

Select B1:B100 >> Data Validation >> "Allow", choose: Custom >> "Formula", enter:

=(ROW()>(A$1+A$2))*(ROW()<=(A$1+A$2)*2)

>> OK

Regards
Bosco