Results 1 to 4 of 4

totals in pivot table

Threaded View

  1. #1
    Registered User
    Join Date
    02-12-2006
    Posts
    10

    totals in pivot table

    Hi
    I have not come in here in a while, but people were very helpful, hopedully someone can assist.

    This may be hard to explain, first let me state I am not familiar with excel jargon and advanced formulas.

    I was given a pivot table where each person has 2 rows -1 represents overtime (OT) and the other is Regular time (REG), now I need one cell adjacent to that to tell me the total of both rows for each person .

    If the list was minimal I would just do "=sum(cell x + Cell y)", but i have like 2000 people.....is there any easier way.

    SEE EXAMPLE ATTACHED- so I would like F2 + F3 in cell G3

    Thanks
    Lushus
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1