How can I set a specific range for my pivot table to use when performing an aggregation?

[rageagainstjg]

I'm having trouble working with Excel right now and need some help. I'm trying to do something that seems simple: I want to specify a range of values for Excel to use when calculating an average in a pivot table, but I'm not sure how to set it up. Could you take a look at the video and share your advice?

 

[Alex Blakenburg]

The easiest would be to add a helper column in your source data and put that in the filter area of your pivot table.
Also please update your profile to show which version of Excel users and the solution often varies based on the version of Excel.

Book1
	A	B	C	D	E	F	G	H	I
1	Hole Number	blastability	Include		Include:	From	7	To	12
2	86844	0	Out of Range
3	86844	5.5	Out of Range		Include	Value lies between 7 and 12
4	86844	6.2	Out of Range
5	86844	7.3	Value lies between 7 and 12		Row Labels	Average of blastability
6	86844	8	Value lies between 7 and 12		86844	9.075
7	86844	9.7	Value lies between 7 and 12		Grand Total	9.075
8	86844	11.3	Value lies between 7 and 12
9	86844	12.2	Out of Range
10
HoleNumbers

Cell Formulas
Range	Formula
C2:C9	C2	=IF(AND(B2>=$G$1,B2<=$I$1),"Value lies between " & $G$1&" and "& $I$1,"Out of Range")