sum quarter

**redsox0407** · 03-12-2012, 10:25 AM

I have 3 columns; Date/Calls/Distributions. The information is entered only on dates where a call or distribution has happened. In a table on a different sheet, the quarterly totals are entered. I'm trying to write a formula that can be applied to the column in the totals table that sums up the calls/distributions automatically. I only enter a new line on the table at the end of a qtr, so no need for a mtd.

**zbor** · 03-12-2012, 10:29 AM

Do you mean something like this:

**redsox0407** · 03-12-2012, 10:43 AM

Kind of. The table has about 6 other columns in it tho and is used to generate multiple charts, so optimal solution would be keeping it in a simpler table form if possible and just having a formula that sums everything in the previous quarter

**daddylonglegs** · 03-12-2012, 10:55 AM

Try this formula in sheet2 E4 copied to F4 then down both columns

=SUMIFS(Sheet1!B:B,Sheet1!$A:$A,">"&EOMONTH($C4,-3),Sheet1!$A:$A,"<="&$C4)

Edit: if you don't want to see the zero values then use a custom format, something like this

#,##0;;