Cumulative Total (With Conditions)

[Citrusandsage]

Hi All,
So I was notified that our sales compensation plans will be based on a quarterly number not a YTD number. Therefore I need to be able to do a cumulative total but just by the quarter and then each quarter needs to start over again. I posted a picture of ideally how I would expect the formula to work, I cant figure out if I can do this by formula or if I am going to have to do this manually every quarter.

Each sheet will be different as the number of contracts someone sells will vary so would be great to be able to do a running total but only if XX cell = Q1 and so on. Any help would be appreciated

 

[Fluff]

Assuming that data starts in A1, put this in C2 & copy down

=SUMIFS(B$2:B2,A$2:A2,A2)

 

[Citrusandsage]

Assuming that data starts in A1, put this in C2 & copy down

=SUMIFS(B$2:B2,A$2:A2,A2)

omg!!!! You are a LIFESAVER thank you SOOOOOOO MUCH

 

[Fluff]

You're welcome & thanks for the feedback.