ExcelBanter - getpivottable function?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - getpivottable function? (https://www.excelbanter.com/excel-worksheet-functions/111704-getpivottable-function.html)

cdi

getpivottable function?

can you add two cells in a getpivottable function?

Debra Dalgleish

getpivottable function?

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

All times are GMT +1. The time now is 01:25 PM.