Change monthly data in quarterly data based on site

[JeanM01]

Hello everyone,

I have data that looks something like this

ID	MOS	Payment	Volume
1001A	Nov-13	$100	80
1001A	Dec-13	$125	70
1001A	Jan-14	$160	20
.	.	.	.
.	.	.	.
1001A	Apr-15	$ -	0
1001B	Jan-12	$200	10
1001B	Feb-12	$200	15
1002A	Jan-14	$900	5

<tbody>
</tbody>

In new columns, I would like to output the quarterly sum or average of these numbers within a year. I can't use an offsetting formula because some sites have less data than others others. And not every month will have data.

Thanks in advance,
Jean

 

[pbornemeier]

This formula will return the sum of payments in 15Q3
=SUMIFS(C:C,B:B,">9/30/2015",B:B,"<1/1/2016")

This formula will return the average of payments in 15Q3
=AVERAGEIFS(C:C,B:B,">9/30/2015",B:B,"<1/1/2016")

 

[JeanM01]

This formula will return the sum of payments in 15Q3
=SUMIFS(C:C,B:B,">9/30/2015",B:B,"<1/1/2016")

This formula will return the average of payments in 15Q3
=AVERAGEIFS(C:C,B:B,">9/30/2015",B:B,"<1/1/2016")

This is certainly helpful. If I could put this all in one column that would be better but thank you!

 

[pbornemeier]

How do you want it to look in a single column?
What row should it appear in?
Try this
="15Q3 Avg Payment: $" & AVERAGEIFS(C:C,B:B,">9/30/2015",B:B,"<1/1/2016") & " Total Payment $" & SUMIFS(C:C,B:B,">9/30/2015",B:B,"<1/1/2016") & " Total Volume: " & SUMIFS(D:D,B:B,">9/30/2015",B:B,"<1/1/2016")