The Everyday Collection — Learn. Make. Read. Discover.
← Back to Microsoft Excel
Microsoft Excel

Sumif, Sumifs, Countif and Countifs

Conditional functions calculate only the records that meet specified criteria. SUMIF and COUNTIF use one condition, while SUMIFS and COUNTIFS can apply several conditions at the same time.

How would you like to use this resource?

Purchase this resource or use an active membership to open it.
Protected previewPurchase this resource or use an active membership to open the complete PDF.
About this resource

Designed for A4 Portrait printing. Keep your printer set to actual size for the intended result.

Recommended material: Paper
£2
Buy Now for £2

Secure Stripe checkout is being prepared. You may add this resource to your basket, but no payment will be attempted until checkout is securely enabled.

Or view Membership for access
MORE FROM

Microsoft Excel

Protected previewPurchase this resource or use an active membership to open the complete PDF.

Getting Started with Excel

View resource →Protected previewPurchase this resource or use an active membership to open the complete PDF.

Entering and Editing Data

View resource →Protected previewPurchase this resource or use an active membership to open the complete PDF.

Formatting Cells and Worksheets

View resource →Protected previewPurchase this resource or use an active membership to open the complete PDF.

Basic Formulas and Calculations

View resource →Protected previewPurchase this resource or use an active membership to open the complete PDF.

Relative, Absolute and Mixed Cell References

View resource →Protected previewPurchase this resource or use an active membership to open the complete PDF.

Essential Functions

View resource →Protected previewPurchase this resource or use an active membership to open the complete PDF.

If and Ifs Logical Formulas

View resource →Protected previewPurchase this resource or use an active membership to open the complete PDF.

Xlookup and Vlookup

View resource →