excel

TwitterFacebook
Get flash to fully experience Pearltrees
array

pivot

See Also: Custom Function For Multi-Condition Summing | Array Formulas | Count with multiple criteria | Conditional summing | Conditional date summing | Sum Every Nth Cell | Sum The x Largest or x Smallest Number in a Range | Count Only One Occurrence IF YOU ARE USING 2007 or above, USE SUMIFS . FREE EXCEL HELP There are many times that it become necessary to SUM cells based on multiple criteria. The examples below will show you 3 ways that this can be done.

Excel: SumIf with Multiple Criteria. Excel Formulas & Functions

http://www.ozgrid.com/Excel/sum-if.htm

spreadsheet

Project Home Page Tracker - Bugs ( 6 open / 51 total ) Bug Tracking System - Support Requests ( 0 open / 12 total ) Tech Support Tracking System - Patches ( 7 open / 10 total ) Patch Tracking System - Feature Requests ( 1 open / 11 total ) Feature Request Tracking System http://rubyforge.org/projects/spreadsheet/