Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    388
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Writing a formula in a pivot table & being able to copy it to other cells

    I wrote a formula in cell E9 in the attached worksheet in the Pivot Table tab. I want to copy this formula to all the other celles in the column ( E5 thru E53) However, I could never accomplish this because of the nature of the Pivot table not being able to identify relative cell adresses.

    Is there a way to accomplish this copying a formula in a pivot table?

    Thank you.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Use:
    =IF(RIGHT(A9,5)="Total",D9-160,"")
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •