SUMIF + IF?

[MICRO]

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

[Don]

Hey Lisa!

You just need a sumifs() function for this (new in Excel 2007). So, try this in cell J20:

Code: Select all

=SUMIFS($F$12:$F$24,E12:E24,I20,G12:G24,"yes")

hth!

[MICRO]

Thanks Don, it works! Yay!

Thanks once again!! Really appreciated! )

Regards/Lisa