In reply to Agnes Sumareke.

You might need something more powerful than Excel to do a proper repeated measure analysis. If you were using SAS, you could use PROC MIXED as in this example. My advice is to consult with a statistician in your organization who knows how to use more powerful software. I don't think the negative values will require special handling.