Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Array Issue, Vertical and Horizontal criteria

  1. #1
    New Member
    Join Date
    Apr 2015
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Array Issue, Vertical and Horizontal criteria

    Hi All,

    I have an issue that I am hoping someone can help me with.

    31/10/2017 Manual Entry
    Orange Manual Entry
    31/07/2017 31/08/2017 30/09/2017 31/10/2017 30/11/2017
    Apple 65,906.16 64,208.91 60,553.10 61,147.29 (65,168.44)
    Orange 82,423.36 79,439.45 75,067.83 74,999.98 (79,986.86)
    Pear 123,138.64 118,918.98 110,543.63 109,319.51 (52,070.06)
    Bananas 1,519.50 1,494.96 1,470.08 - -
    {=SUM(IF(($B$3:$F$3<=F1),B4:F4))} 251,815.46

    The above calculates sum of "apple" row to 31/10; based on F1; I can outline a single row with one criteria only.

    I would like to add one more criteria (F2) to the above formula and to increase the sum range from B4:F4 to B4:F7 so that whatever date and fruit is manually input, I will get the sum of the figures of that fruit up til the date.

    Any help/advice on this will be appreciated.

    Thank you

    AQ

  2. #2
    New Member
    Join Date
    Apr 2015
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Array Issue, Vertical and Horizontal criteria

    All,

    Please disregard the above, found the solution.

    Thank you

    AQ

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
  •