Calculating the PTD Sum

[Sri.n]

Can anyone help me or suggest any function which calculates the period to date sum in excel, where I have the numbers for entire year but I would need the sum only for the particular week/period.

I have attached an example for reference.

Any help would be highly appreciated

Regards,
Sri

[:) Sixthsense :)]

In O5 Cell

Please Login or Register  to view this content.

Drag it down...

[akhileshgs]

are you looking for something like this?
Example (1).xlsx
But here u r putting the week and period manually...

I am sure that you can convert that also to formula based one.
But may have to raise another topic for that

[Sri.n]

Hi Akhileshgs/Sixthsense .. your examples really helps the same thing I am applying on this sheet but I am not able to get the output.. is der any mistake I am doing.

[akhileshgs]

dont u think that the reriod and week are reversed after colored cell?
I am getting the correct data for weeks below 4

[:) Sixthsense :)]

In O12 Cell

Please Login or Register  to view this content.

Drag it down...