Creating Average Values by spliced data

[draconius]

Is it possible to have the AVERAGE of data by the spliced category? IE., [TABLE="width: 300"]
<tbody>[TR]
[TD]January[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]February[/TD]
[TD]35[/TD]
[/TR]
[TR]
[TD]March[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD]April[/TD]
[TD]36[/TD]
[/TR]
[TR]
[TD]May[/TD]
[TD]42[/TD]
[/TR]
[TR]
[TD]June[/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD]July[/TD]
[TD]29[/TD]
[/TR]
</tbody>[/TABLE]

If I splice out to select Q1 my value for the Chart would have a value of 29.3

Is that possible?

 

[Rijnsent]

Hi draconius,
you could calculate that in 2 steps: 1) add a column with the quarter (hard-coded or with a formula) and 2) use an AVERAGEIF(S) formula to get the average of e.g. Q1. The alternative for 2) is to create a pivot table with the data and show the average value there.
Cheers,
Koen