Close

Results 1 to 1 of 1

Thread: Excel question

  1. #1
    DF VIP Member Karoline's Avatar
    Join Date
    Dec 2004
    Location
    UK
    Posts
    2,551
    Thanks
    106
    Thanked:        59
    Karma Level
    466

    Attention Excel question

    How can i do a formula that will calculate the average of a few cells as long
    as the cell is over a certain amount... ??

    Eg, i have

    40
    42
    45
    30

    I would like the average of all of them expect any that are lower than 35

    e.g if(a1:a4<35,takeaverage,ifnotexcludeanythinglower)

    ^^ i know that will not work but i am sure someone will know how to make it
    work..


    Ok, i now have the answer
    =AVERAGE(IF(A1<35,IF(A1<>"",A1)))


    But is there a way to do the graph below... ??



    Also i would also like to may a graph with the above information selecting all the 4 cells, but would not like anything other than 35 on the graph...
    Is this possible?
    Last edited by Karoline; 3rd June 2009 at 08:20 PM.

Similar Threads

  1. redirect question
    By Psychoschiz in forum Web Hosting & Domain Names
    Replies: 2
    Last Post: 26th September 2002, 04:09 PM
  2. Quick Saturn question
    By doughboy in forum Old Skool Gaming & Retro
    Replies: 1
    Last Post: 16th September 2002, 02:19 AM
  3. Xbox DVD Rom question
    By nims076 in forum Microsoft Consoles
    Replies: 12
    Last Post: 1st September 2002, 04:21 PM
  4. 5210 question
    By miniboot in forum Unlocking Questions & Solutions
    Replies: 1
    Last Post: 29th August 2002, 12:36 PM
  5. Decorating Question
    By Roty in forum The Dog and Duck
    Replies: 6
    Last Post: 28th August 2002, 11:36 AM

Social Networking 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
  •