Hi All,
I have an issue that I am hoping someone can help me with.
[TABLE="width: 693"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]31/10/2017[/TD]
[TD]Manual Entry[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Orange[/TD]
[TD]Manual Entry[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]31/07/2017[/TD]
[TD]31/08/2017[/TD]
[TD]30/09/2017[/TD]
[TD]31/10/2017[/TD]
[TD]30/11/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]65,906.16[/TD]
[TD]64,208.91[/TD]
[TD]60,553.10[/TD]
[TD]61,147.29[/TD]
[TD](65,168.44)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]82,423.36[/TD]
[TD]79,439.45[/TD]
[TD]75,067.83[/TD]
[TD]74,999.98[/TD]
[TD](79,986.86)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pear[/TD]
[TD]123,138.64[/TD]
[TD]118,918.98[/TD]
[TD]110,543.63[/TD]
[TD]109,319.51[/TD]
[TD](52,070.06)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]1,519.50[/TD]
[TD]1,494.96[/TD]
[TD]1,470.08[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"]{=SUM(IF(($B$3:$F$3<=F1),B4:F4))}[/TD]
[TD]251,815.46[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 656"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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
I have an issue that I am hoping someone can help me with.
[TABLE="width: 693"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]31/10/2017[/TD]
[TD]Manual Entry[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Orange[/TD]
[TD]Manual Entry[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]31/07/2017[/TD]
[TD]31/08/2017[/TD]
[TD]30/09/2017[/TD]
[TD]31/10/2017[/TD]
[TD]30/11/2017[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]65,906.16[/TD]
[TD]64,208.91[/TD]
[TD]60,553.10[/TD]
[TD]61,147.29[/TD]
[TD](65,168.44)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange[/TD]
[TD]82,423.36[/TD]
[TD]79,439.45[/TD]
[TD]75,067.83[/TD]
[TD]74,999.98[/TD]
[TD](79,986.86)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pear[/TD]
[TD]123,138.64[/TD]
[TD]118,918.98[/TD]
[TD]110,543.63[/TD]
[TD]109,319.51[/TD]
[TD](52,070.06)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Bananas[/TD]
[TD]1,519.50[/TD]
[TD]1,494.96[/TD]
[TD]1,470.08[/TD]
[TD] -[/TD]
[TD] -[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"]{=SUM(IF(($B$3:$F$3<=F1),B4:F4))}[/TD]
[TD]251,815.46[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 656"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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