About EDC
     Contact
     Feedback

VBA programming
     Add-Ins
     ADO/DAO
     Charts
     Dialogs/UserForms
     Display/Statusbar
     Events
     Files/Folders
     Import/Export
     Menus/Toolbars
     Misc. tips
     OLE Automation
     Operating System
     Printing
     Private Profiles
     Sound
     VBA File Access
     Visual Basic Editor
     Workbooks
     Worksheets

Worksheet Functions
     Adding
     Counting
     Date
     Lookup
     Misc. Functions
     Time

Download

Help / Support

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Conditional sum

With the worksheetfunction SUMIF() it's possible to return the sum of all cells in a given range that fulfils a given criteria.

The function =SUMIF(A1:A100,">1000") will return the sum of all values in the range A1:A100 that is greater than 1000.

The function =SUMIF(A1:A100,">1000",B1:B100) will return the sum of all values in the range B1:B100 that has an adjacent cell in the range A1:A100 that is greater than 1000.

You can also use the COUNTIF()-function in a similar way to perform a conditional count.

Document last updated 1999-08-14 12:44:13      Printerfriendly version