+ Reply to Thread
Results 1 to 1 of 1

Excel 2010 how do I make an average of cells in multiple .XLSX fies

  1. 03-27-2014, 12:16 PM #1
    MannyLNJ
    MannyLNJ is offline
    Registered User
    Join Date
    02-12-2010
    Location
    Toms River, NJ
    MS-Off Ver
    Excel 2010
    Posts
    42

    Excel 2010 how do I make an average of cells in multiple .XLSX fies

    I have 52 spreadsheet files each representing one week in the year. Each file has a tab for the day of the week.

    I need to make another spreadsheet that will tell me the average # of calls for a day of the week (mon, tue, wed, etc) not a specific day for the year.

    How do I do this?
    Attached Files Attached Files
    Last edited by MannyLNJ; 03-27-2014 at 12:25 PM. Reason: Added generic file
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2010 Average Ignoring Zero Values - Non-consecutive cells
    By a7mad3wies in forum Excel General
    Replies: 5
    Last Post: 12-04-2013, 04:54 AM
  2. [SOLVED] Excel 2010 Average Ignoring Zero Values - Non-consecutive cells
    By lanos in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-23-2013, 07:28 PM
  3. Weighted average w/ multiple text criteria excel 2010
    By mischge in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-31-2013, 11:34 AM
  4. Can't make a chart with multiple lines in excel 2010
    By bmiranda in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-18-2013, 10:32 AM
  5. Quattro Pro X5 (.qpw) to Excel 2010 (.xlsx) conversion
    By ivabos in forum Excel General
    Replies: 6
    Last Post: 04-19-2012, 03:27 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1