119. Calculating Multiple-Criterion Conditional Sums
Published Online: 11 NOV 2011
DOI: 10.1002/9781118257647.ch119
Copyright © 2010 Wiley Publishing, Inc., Indianapolis, Indiana
Book Title
John Walkenbach's Favorite Excel® 2010 Tips & Tricks
Additional Information
How to Cite
Walkenbach, J. (2010) Calculating Multiple-Criterion Conditional Sums, in John Walkenbach's Favorite Excel® 2010 Tips & Tricks, Wiley Publishing, Inc., Hoboken, NJ, USA. doi: 10.1002/9781118257647.ch119
Publication History
- Published Online: 11 NOV 2011
- Published Print: 28 JUN 2010
ISBN Information
Print ISBN: 9780470475379
Online ISBN: 9781118257647
- Summary
- Chapter
Keywords:
- multiple-criterion conditional sums;
- array formula;
- difference range;
- Worksheets;
- Sumifs function
Summary
This chapter contains sections titled:
Using “And” criteria
Using “Or” criteria
Using “And” and “Or” criteria