Sum Column Until Condition Is Reached

Hello,

I have 3 columns: Column A has categories: Column B has Amounts, and I would like Column C to auto sum every time there is a new category in A. 

So if A1 is my category, Green, and B1:B? is my expenses for the category Green, I would like C1 to keep adding up Column B expenses, UNTIL a new category was entered in Column A, at which point it would STOP summing completely. Entering a new category in Column A would start a new auto-sum of column B, until a new category was entered in A, etc, etc. 

The categories in A would not necessarily be enterd

Is this possible through formulas only? Am I asking for the moon? 

 

Image

 

 

 

 

 

By: acarcich

2,313 thoughts on “Sum Column Until Condition Is Reached

  1. Aptoide Box Tv

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. toko online 88

    After looking into a few of the blog articles on your web site, I seriously like your technique of writing a blog. I book marked it to my bookmark webpage list and will be checking back soon. Please visit my website too and tell me your opinion.

  3. genolyze

    Spot on with this write-up, I really feel this website needs a great deal more attention. I’ll probably be returning to read more, thanks for the information!

  4. Moedah

    Everything is very open with a precise clarification of the issues. It was truly informative. Your site is very helpful. Thanks for sharing!

  5. App Perfect Player Para Smart Tv

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  6. fancy text

    Good day very nice website!! Man .. Beautiful .. Superb ..
    I will bookmark your blog and take the feeds additionally?
    I am glad to search out a lot of helpful info here in the submit, we’d like
    work out more strategies on this regard, thanks for sharing.

    . . . . .

  7. vivoslot.online

    Hi, I believe your web site could be having web browser compatibility issues. Whenever I take a look at your site in Safari, it looks fine however, if opening in IE, it’s got some overlapping issues. I merely wanted to provide you with a quick heads up! Aside from that, great website!

Comments are closed.