Thanks:  0
Likes:  0

# Thread: Array Issue, Vertical and Horizontal criteria

1. ## 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. ## Re: Array Issue, Vertical and Horizontal criteria

All,

Please disregard the above, found the solution.

Thank you

AQ