Cumulative sum with a condition

Basically I'm writing above what should happen and what is happening, I guess it'll be easier to understand.
Ps: I uploded the file below.

-----------------------------------------------------------------------------
What IS happening (in the file below):
First entry
if category (categoria) is "mercado", G10 will receive G10 value + K22 value
Segunda entrada
if category (categoria) keeps being "mercado", G10 will receive G10 value + K23 value
Terceira entrada
if category (categoria) keeps being "mercado", G10 will receive G10 value + K24 value
Quarta entrada
if category (categoria) IS NOT "mercado", but "lazer" G9 will receive G9 value + K25 value
Quinta entrada
if category (categoria) is "mercado" again, G10 will receive G10 value + K26 value

This way when I change K22 value in the table, G10 won't change.
-----------------------------------------------------------------------------

What SHOULD happen:
First entry
if category (categoria) is "mercado", G10 will receive K22
Second entry
if category (categoria) keeps being "mercado", G10 will receive K22+K23
Third entry
if category (categoria) keeps being "mercado", G10 will receive K22+K23+K24
Fourth entry
if category (categoria) IS NOT "mercado", but "lazer", for example, G9 will receive K25
Quinta entrada
if category (categoria) is "mercado" again, G10 will receive K22+K23+K24+K26

This way I'm able to change K22 value in table and it will change in G10.
And it should work for the nexts entries, with this same pattern.
-----------------------------------------------------------------------------

In order to insert any data, click on "INSERIR DEPESAS".

Thanks,
Luiz.

I uploaded the file in my dropbox account because it's larger than 1000kb.
https://www.dropbox.com/s/6ckoef66ug...este.xlsm?dl=0

If it is too large to load here, then make it smaller. All we need is enough data to see what you are working with, and what you want.

Please upload your file to the forum. Not all members are able - or willing - to access file-hosting sites

Hello luizmachado,

Have you tried to convert your Workbook to a "Zip" format, and check if it may then be smaller than 1Meg?

Even if that does not work, just upload a downsized sample Workbook, which should be good enough for us to work from.

Regards.

P.S.

@ FDibbins,

Please stop being faster than me!

LOL jammer ou maat
Hey, coming to SA again in august

maybe this?
=SUMIF(D:D,D22,L:L)

Simple is always best

Happy to help and thanks for the feedback