Hi - Dave here.
Happy Friday!
Let's start off the new year with a simple formula.
In the screen below, the goal is to sum the amounts in C5:C16 when corresponding values in D5:D16 are
not blank. The formula in cell G5 is:
=SUMIFS(C5:C16,D5:D16,"<>")
The main challenge with SUMIFS is the quirky syntax. For criteria, we simply use the "not equal to" operator, "<>". We don't provide a value, and it's implied that this means "not equal to nothing", i.e. "not blank".
[
Download the workbook and read the full explanation]
As always in Excel, there is more than one way to skin the cat. The article above also shows how to solve the same problem with the SUMPRODUCT function and with the FILTER function. There are also links to 3 short videos for background study. Download the workbook and try it out yourself.
New shortcut PDF
In case you missed it, we released a new version of our Excel Shortcut PDF before the holidays. You can download the new version
here.
More Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a nice weekend!
Dave
