Results 1 to 9 of 9

Average 3 to 5 numbers

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2011
    Posts
    13

    Average 3 to 5 numbers

    I had used this forum before when you had helped set up the excel sheet that I will upload. We now have close to 300 candidates on the list but have run into a problem.

    We usually had 3 interviewers as seen on sheet 3, however, now for some candidates I have 4 or 5 interviewers. In that case I need to average the 4 or 5 interviewers & have the next candidate start beneath that. I think the sheet 3 is programmed to space every 4 cells then display the average for the next candidate. How can I go about integrating it to skip 5 spaces if there were 4 interviewers & skip 6 spaces if there were 5 interviewers?

    For example for Candidate 6 on Sheet 3, I want the average of 12 to be displayed on H28 instead of H27. For Candidate 7 I need the average to be displayed on H34 without any numbers in between. But if Candidate 8 has only 3 interviewers then it should only skin 4 cells & then display the average in the subsequent cell. Does that make sense?

    I have uploaded the sheet.

    Thank you SO much for your help!
    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