# Formula For Monthly Totals

May 20, 2009I need to create a running monthly total formula for a worksheet. This is something i need in the data, so i can manipulate it without using a pivot table.

I think I would use the SUM, MONTH, and IF formulas, and maybe EOMONTH.

I guess where I'm stuck is figuring out how to make conditions for my SUM formula. So as the dates go down the page, I would like a running total in a column to the right, that will also restart with every new month.

Attached is my example.