Professor Excel

Comments 2

  1. Ron

    You say that “That’s why direct cell links are in most cases a better solution.” Can you please give examples when GETPIVOTTABLE would be the preferred solution?

    • Henrik Schiffner

      Hi Ron,
      Sometimes you want to make sure you grab the “Grand Total”, for example. With each update of the data it could be located in a different cell. So in such case “GETPIVOTTABLE” could be a preferred solution. Although probably a SUMIFS would be a better solution here…
      What do you think?

Leave a comment

%d bloggers like this: