Cumulative sum with multiple criteria

[camilaarbigaus]

Hi all, I am trying to calculate the percentiles in a frequency table, but I'm having trouble creating the cum sum with multiple criteria - the idea is to replicate the values in column D

State	Color	Count	Cum. sum for "blue" per state
Alabama	Blue	2	2
Alabama	Yellow	4
Alabama	Blue	6	8
Alabama	Red	8
Alabama	Red	10
Alaska	Yellow	11
Alaska	Blue	3	3
Alaska	Red	4

I was able to calculate the cum sum per color, but not accounting for state with the following formula (in google sheets - and I don't know if this is the best way as I'm finding some errors in the way):
=IF(B2<>"Blue","",c2+ArrayFormula(LOOKUP(2,1/(ISNUM(D$1:D2)),D$1:D2)))

Does anybody have any idea on how to do it? With the cumulative sum, I'll be able to calculate the percentiles per state per color

Thnak you very much!!

 

[Fluff]

In future please post questions for Sheets in the General Discussion & Other Applications section of the board.
I have moved it for you this time.

 

[Fluff]

Maybe

=IF(B2<>"Blue","",sumifs(c$2:C2,A$2:a2,a2,B$2:B2,"Blue"))

 

[camilaarbigaus]

Maybe

=IF(B2<>"Blue","",sumifs(c$2:C2,A$2:a2,a2,B$2:B2,"Blue"))

Genious! Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.