Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Formula Problems

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Oklahoma
    Posts
    237
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does anyone know why this formula will not work? Thanks for any help.

    =SUMIF($C$6:$O$6,"Actual",AVERAGEA(C19:O19))

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,026
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-05-09 07:06, Aaron wrote:
    Does anyone know why this formula will not work? Thanks for any help.

    =SUMIF($C$6:$O$6,"Actual",AVERAGEA(C19:O19))
    The syntax is not good: You could maybe state what you'd like to do?

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Oklahoma
    Posts
    237
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a range of cells that are %'s, and they will change every four weeks. I want to try and get the average of a certain range when the four weeks change. For instance: in range("A1:M1") are my percentages. This month I want the average of Range("A1:D1"), then next month Range("A1:E1"). Does this help any. I know my questions are really scattered brained, but I appreciate the help. -asa

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,026
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    Aaron,

    It's:

    =SUMIF(C6:O6,"Actual",C19:O19)/MAX(1,COUNTIF(C6:O6,"Actual"))

    where C6:O6 houses fields like "Actual" and C19:O19 corresponding percentages that you want to average depending on the field that figures as condition/criterion.

    Aladin

    [ This Message was edited by: Aladin Akyurek on 2002-05-10 04:34 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •