Results 1 to 4 of 4

Thread: Sum of last 5 values higher than zero
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Sum of last 5 values higher than zero

    Hi, I am trying to sum the last 5 non zero values in row 241. . Please help.

    Also posted here https://www.excelguru.ca/forums/show...gher-than-zero
    Last edited by Fluff; May 14th, 2019 at 11:53 AM.

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,409
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Sum of last 5 values higher than zero

    Try this array formula

     AHAI
    24118.7 

    Array Formula
    {=SUM(IF(COLUMN(C241:AG241)>=LARGE(IF(C241:AG241>0,COLUMN(C241:AG241)),5),C241:AG241))}


    Array formulas
    Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
    Note: Do not try and enter the {} manually yourself
    Regards Dante Amor

  3. #3
    New Member
    Join Date
    May 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sum of last 5 values higher than zero

    Thank you so much!!!!!

  4. #4
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    4,409
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Sum of last 5 values higher than zero

    I'm glad to help you. Thanks for the feedback.
    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

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
  •