Basic Pivot Table Question

[Raeven]

I have read several websites, the MS Excel Help file and numerous posts
I just can't seem to understand the GETPIVOTDATA function very well.
When I enter this formula, it works:

=GETPIVOTDATA('Project Hours Lookup'!$A$4,"M Hours")

However, I can't get any of the other configurations that I've seen o
other websites to work. For example, I can't get it to use more tha
one criterion. For example, I tried:

=GETPIVOTDATA("Hours",'Project Hour
Lookup'!$A$4,"Org","M","CN","1330006806G")

One website says this is structured in a "Field Name", "Criterion
pattern.

I'm not even exactly sure what the arguments are for. Please help.
I'm getting somewhat agitated.

Stephani

 

[Debra Dalgleish]

If you're using Excel 2000, the arguments should be a reference to the
pivot table, then the criteria in double quotes. If any of the criteria
are multiple words, enclose those in single quotes.

For example:

=GETPIVOTDATA('Sheet1'!$A$4,"Units Alberta Jones 'Pen Sets'")

Units is the data field, Alberta and Jones are items in row fields, and
Pen Sets is an item in a column field.