Hi All, new to the forum so thanks in advance for any help offered

I have an excel sheet which has a cell which says 'if Y in field x then date stamp field x'. Another states 'if Y in field x then enter a value (retrieved from another cell)'

That is all working fine, but the purpose of this s/s is to track value earned on a project. So each task is listed in excel, with a value, and when it is complete (enter the Y as above) we earn the value. So I want to know how much value is earned on a cumlative basis. Using a typical cumlative formula doeas not work as tasks completed may not be in order. So row 1 may be completed, then row 15. So as I enter Y into row 15 I want it to give me the sum of row 1 + row 15 value.

As a side I may want to expand this to give me cumlative totals for the week or month