Hi All,
I have an issue that I am hoping someone can help me with.
<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
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