I need a formula to sum financial transactions according to the month; however it is a running total and the number of transactions in each month are initially unknown.
In column A, I have dates (Jan 1st, 2nd, 3rd, etc.) and column B the corresponding financial transactions associated with those dates. The formula needs to be able to read column A and know that if the transaction occurred in January then total in cell C1. If the transaction occurred in February total in cell C2, etc.
An easy way to think of it, would be to imagine your checking account. Sometimes it has multiple transactions on some days and other days it has none. But a running monthly total would be nice even though you may not know the number of transactions that will occur in future.
I've tried several sumif forumlas but keep encountering a circular reference. Appreciate any advice offered...
In column A, I have dates (Jan 1st, 2nd, 3rd, etc.) and column B the corresponding financial transactions associated with those dates. The formula needs to be able to read column A and know that if the transaction occurred in January then total in cell C1. If the transaction occurred in February total in cell C2, etc.
An easy way to think of it, would be to imagine your checking account. Sometimes it has multiple transactions on some days and other days it has none. But a running monthly total would be nice even though you may not know the number of transactions that will occur in future.
I've tried several sumif forumlas but keep encountering a circular reference. Appreciate any advice offered...
