Dear All,
I need to calculate the amount depending if I have received cash or not....
In One month I need to see both what has actually been paid : cash in = Yes. but also the forecast Cash in = No.
Maybe I can use IF + SUMIF?
Please see attached file:
E11 F11 G11
Date Amount Cash in? Actuals: Forecast
2011-11-01 236 791 yes 2011-11-01 236 791 0
2011-12-01 2 735 592 yes 2011-12-01 3 792 775 679 575
2011-12-01 243 532 yes 2012-01-01 0 183 333
2011-12-01 779 369 yes ---------------------------------------------------
2011-12-01 21 896 yes
2011-12-01 12 386 yes
2011-12-01 70 143 no
2011-12-01 122 078 no
2011-12-01 487 536 no
2012-01-01 45 833 no
2012-01-01 45 833 no
2012-01-01 45 833 no
2012-01-01 45 833 no
Thanks a lot,
Lisa