Hi everyone

I need solution for one of the problems i face with updating a cell

my cells are like this

Cell C1 will have sum(B1:B10)

Cells B1 to B10 change daily with a condition b1 = (If(D1=0,e1,0) here d1 will have a positive value only once in a month and all other 29 days it will be zero 0

Similarly B2 to b10 will have one value once in a month and remaining time it will be zero.

C1 should be updated whenever there is value change in b1-b10

it stores only one value since it is sum of b1:b10 .. I need it to get updated with the previous sums also

In My case it should have sum of 10 numbers by the end of the month.

I check the conditions this way =MOD(d1,30) so its going to be 0 only once in a month . When d1 =0 then B1 will get a value to its cell so B1 will have only one positive number in a month.

regards
Prabhu

And the problem is???

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========