Depends on the nature of the data. If you were able to attach a sample or just create one, the picture would be clearer.

Assuming you have dates associates with whatever your're summarizing, you could use SUMIF(S) or SUMPRODUCT.