You can use two GetPivotData functions in one formula:
=GETPIVOTDATA("Units",$B$5,"Region","East")
+ GETPIVOTDATA("Units",$B$5,"Region","West")
cdi wrote:
can you add two cells in a getpivottable function?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html