Excel Update options
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.