Array Issue, Vertical and Horizontal criteria

[Alleemq]

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

<tbody>
</tbody>

<tbody>
</tbody>

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

 

[Alleemq]

All,

Please disregard the above, found the solution.

Thank you

AQ