Excel Question

[VapourTrail]

How do you "close down" a job? Is there a column that says "closed" or a job is deemed close if it has a sign off date or something else?

As suggested, if you have a column to state that the job is 'Closed' then you could use this in the formula to ignore closed jobs from the calculation.