Most regular users of Microsoft Excel are familiar with the SUMIF worksheet formula but it's surprising how many people are unaware of the SUMIFS formula. The SUMIFS formula ultimately supersedes the SUMIF formula as it can be used with multiple selection ranges unlike the SUMIF that utilised just one range.

The SUMIFS formula therefore becomes a very useful sum formula that can be used with both numeric and text criteria. The example below illustrates how useful the SUMIFS formula can be. Like many of the formulas in Excel the SUMIFS formula can be used within IF statements and can be combined with VLOOKUPS, MATCH, INDIRECT etc.

Please feel free to download the example above. I hope you find this post useful.

Darren