Results 1 to 2 of 2

SUM IF? to compare workload by person?

Threaded View

  1. 04-21-2011, 10:22 PM #1
    IsabellaLearning
    IsabellaLearning is offline
    Registered User
    Join Date
    05-26-2010
    Location
    Auckland, NZ
    MS-Off Ver
    Excel 2003
    Posts
    52

    SUM IF? to compare workload by person?

    Am wanting to work out total sum and averages for individuals on 2 shifts then culminate their workload on am and pm shift into another SUM and Avg by individual..

    I have included a sample, if you look at sheet one - its the data and sheet 2 is the setup for the formulas which I think are SUMIF?

    Any assistance would be grand

    Isabella
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1