Sum different sets of data in the same column

Hi All,

Im not the best with excel.

I have a long list of various payment types that i need to sum up. I was thinking maybe a SumIf that would sum everything below Chess (W) until it encountered text again if that makes sense.

[ATTACH=CONFIG]68517[/ATTACH]

Re: Sum different sets of data in the same column

Perhaps i can explain a little better, My end goal is to populate that sheet and have a formula i can drag across that will sum the Chess Qad and Qad EE into this other tab[ATTACH=CONFIG]68518[/ATTACH]
I know this can be done with a simple Sum function but each week the length of the Wires and ACH's vary making that impossible