Hi,
I would like to know if it's possible to divided or even create a formula to
sum up values for a certain amount of row .

Exm: A B C
D
Project /deposit slip ref.# / balance / deposit
balance
1 12053 $16000
2 12053 $10000

sum of rows C if B is same

and

Exm2: A B C
D
Project deposit slip ref # bank fee
balance
1 1234 =20/by rows(4)
2 1234
3 1234

4 1000 =20/by rows (1)



I hope to receive help for any one and I will be very thank full :).

Hi,

Your example didn't paste in too well but I think you may mean this:-

Col A B C D
Pro Dep slip amount Bal
1 12053 1000 1000
2 12053 1100 2100
3 12054 1200 1200
4 12054 1300 2500
5 12055 1200 1200
6 12055 1500 2700
6 12055 2200 4900


The formula in D2 is =C2
Then in D3 enter
=IF(B3=B2,C3+D2,C3)
Drag down as required.

Mike

"susy" wrote:

Hi,
I would like to know if it's possible to divided or even create a formula to
sum up values for a certain amount of row .

Exm: A B C
D
Project /deposit slip ref.# / balance / deposit
balance
1 12053 $16000
2 12053 $10000

sum of rows C if B is same

and

Exm2: A B C
D
Project deposit slip ref # bank fee
balance
1 1234 =20/by rows(4)
2 1234
3 1234

4 1000 =20/by rows (1)



I hope to receive help for any one and I will be very thank full :).

Indeed I did'nt paste, I did type it manually, but it did help thnx;) as far
as I keep it simply,

Becuase later on I will have to protect the formulas because it's a share
workbook. Interns will be making use of it to insert data and I don't want
them to edit any formula. If I allow them to enter a row will the formula
adapt to the extra row or do I have to change it manually?

And

With the other example I wanted to divided the bank fee by the amount of
rows which are equal I think it may be if the rows are equal divided bank
fee by the amount of rows.

"Mike H" wrote:

Hi,

Your example didn't paste in too well but I think you may mean this:-

Col A B C D
Pro Dep slip amount Bal
1 12053 1000 1000
2 12053 1100 2100
3 12054 1200 1200
4 12054 1300 2500
5 12055 1200 1200
6 12055 1500 2700
6 12055 2200 4900


The formula in D2 is =C2
Then in D3 enter
=IF(B3=B2,C3+D2,C3)
Drag down as required.

Mike

"susy" wrote:

Hi,
I would like to know if it's possible to divided or even create a formula to
sum up values for a certain amount of row .

Exm: A B C
D
Project /deposit slip ref.# / balance / deposit
balance
1 12053 $16000
2 12053 $10000

sum of rows C if B is same

and

Exm2: A B C
D
Project deposit slip ref # bank fee
balance
1 1234 =20/by rows(4)
2 1234
3 1234

4 1000 =20/by rows (1)



I hope to receive help for any one and I will be very thank full :).