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?