Results 1 to 5 of 5

Average columns across multiple sheets

Threaded View

  1. #1
    Registered User
    Join Date
    04-24-2007
    Posts
    9

    Average columns across multiple sheets

    I have 10 sheets in my workbook that represent 10 employees. Column G, rows 5 through 739, represent the amount of time each employee spends doing a certain task for each day of the year. All these cells have zeros in them until a we come to that day and a time is entered for that day. The result in each cell is a certain amount of minutes spent on that task.

    I can average each employees time individually on it's own sheet with this formula: {=AVERAGE(IF(G5:G739=0,"",G5:G739))}, but what I'm having a problem doing is averaging all 10 employees together on a separate sheet. I'm trying to figure out company wide how much time is spent on this particular task each day.

    My depth of understanding here isn't too great, I'm learning as I go. I think I have to incorporate that formula while also selecting each sheet. I'm starting to get the BSOD in my head with this one.

    Hopefully I've given enough info that someone can help me through this. Probably a basic problem for most of you, unfortunately, not for me.

    Thanks.
    Last edited by Stayfair; 10-04-2008 at 03:06 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Hiding the same column on multiple sheets
    By cbjorgol in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2013, 01:19 AM
  2. find and copy text from multiple sheets / columns
    By cfeedback in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-03-2008, 11:35 PM
  3. Coverting Multiple columns of data into 3 columns
    By carricka in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2008, 07:26 AM
  4. SUMPRODUCT across Multiple Sheets in the same workbook
    By Adrian17 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-23-2007, 01:41 PM
  5. Searching multiple columns on multiple sheets
    By jonhunt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2007, 12:25 PM

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