Using SUMIF
in Microsoft Excel 2007
2009.0104
SUMIF is a very powerful and easy-to-use Excel function. Here's a simple illustration.
[NOTE: I recently became aware that the video on this page
was not working. This has been corrected, but the audio and video may be out of sync
during playback -- and it may take longer for the file to load (so please be patient).
Correcting this problem will require the session to be reproduced at a later date. The
session is still useful meanwhile, so long as you are aware of this problem.]