raywilliamjohnson
New member
- Joined
- Jul 1, 2015
- Messages
- 7
- Reaction score
- 0
- Points
- 0
- Location
- jakarta, indonesia
- Excel Version(s)
- 2007
hi im trying to make automatic calculation without block spesific column
for example if I want investagate formula under B2 (B3and below) I had to write a name in cell B3 after that I have to copy and block range C2:M2 to get the result to below. the result from C3:M3, C4:M4 etc is not same as cell B2 but depending on Text/Name written in cell B3 and below.
is there any formula which automatically counting data from cell C2 : M2 when we typing in a name under the cell B2 (b3, b4, b5, b6 etc)?
is there is something wrong with the formula that I wrote so data doesnt update automatically?
for example if I want investagate formula under B2 (B3and below) I had to write a name in cell B3 after that I have to copy and block range C2:M2 to get the result to below. the result from C3:M3, C4:M4 etc is not same as cell B2 but depending on Text/Name written in cell B3 and below.
is there any formula which automatically counting data from cell C2 : M2 when we typing in a name under the cell B2 (b3, b4, b5, b6 etc)?
is there is something wrong with the formula that I wrote so data doesnt update automatically?