SUMIF - More than 1 Criteria in Excel 2007

The SUMIF function can be used to sum a range on cells based on certain criteria.
With Excel 2007, Microsoft introduced another addition to SUMIF i.e. SUMIFS that allows you to pass more than one criteria. Both SUMIF and SUMIFS have been explained in the attached workbook. Try changing the values in yellow cells and see how the result under sales column changes...
Attachment | Size |
---|---|
SumIf.xlsx | 10.72 KB |
SumIf 2003.xls | 29.5 KB |
»
- Vishesh's blog
- Login or register to post comments
- 11858 reads
Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago