|Add cells specified by a given condition or criteria.|
|=SUMIF( range, criteria, [sum_range] )|
|range||The range of cells that you want to apply the criteria against.|
|criteria||The criteria used to determine which cells to add.|
|[sum_range]||The cells to add together. If sum_range is omitted, the cells in range are added together instead.|
Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.