Microsoft Excel Public Courses in London. Onsite Courses Nationwide.

Call us on 020 7183 7740

Lines open 9am to 6pm

Email us enquiries@weareexcel.co.uk

A Short Guide to using Excel’s SUMIF Function

Ever needed to add up numbers on your Excel spreadsheet that meet a certain criteria – E.G. only numbers above a certain value. Excel’s SUMIF function will allow you to total up numbers in range that meet the criteria that you set using the SUMIF function. Click on the link below to open a short PDF guide showing the steps needed to do this (posted by Chris James on 25/09/2015)

Logical Functions IF SUMIF COUNTIF