I am looking for a way to formulate in A2:A4 so it counts B to D in the same
row if B1 is greater than A1 and the same for C and D. Below is a example of
before and after.

Thank you


Before
A B C D
1 7/31/09 3/2/09 4/13/09 8/1/09
2 10 9 8
3 5 10 15
4 20 25 30

After
A B C D
1 7/31/09 3/2/09 4/13/09 8/1/09
2 19 10 9 8
3 15 5 10 15
4 45 20 25 30