Hi All,

I have the following formula to show progress of an item at a particular date:

=IF($D329<"",IF($D329<=V$3,($D$341/100)*$S329),0)+IF($E329<"",IF($E329<=V$3,($E$341/100)*$S329),0)+IF($F329<"",IF($F329<=V$3,($F$341/100)*$S329),0)+IF($G329<"",IF($G329<=V$3,($G$341/100)*$S329),0)+IF($H329<"",IF($H329<=V$3,($H$341/100)*$S329),0)+IF($I329<"",IF($I329<=V$3,($I$341/100)*$S329),0)+IF($J329<"",IF($J329<=V$3,($J$341/100)*$S329),0)+IF($K329<"",IF($K329<=V$3,($K$341/100)*$S329),0)

V3 is the current date, S329 is the budgeted hours, D329:K329 are
deliverable dates, and D341:K341 are progress percentages...

Basically it's adding the values in the progress percentages in D341:D341 if
the corresponding date with D329:K329 is before the date in V3 and then
multiplying by the budget figure.

Is there any obvious way to simplify? Maybe an array formula?

Cheers as ever!
Marc