Paul Wherly

Tip: CountIF and SumIF in Excel

Count or Sum the entries if your criteria are met – Excel 2007,2010 and 2013

Here is a list of the CDs in a collection and their cost:



The SUMIF function adds up a list of figures based on the criteria that you set. In my example above I want to add up the total value of CDs based on the Genre.

1. Click into the cell where you require the answer sumIF

2. Type an = sign

3. Type SUMIF and an open bracket

4. Now select the range of cells that has the criteria in it

5. Type a comma

6. Add the criteria (if the criteria is a text value as here it needs to be enclosed in double quotation marks

7. Then type another comma

8. Now select the range of cells that contain the values you wish to add up

9. Type a closing bracket

10. Press Enter


If you would like to have us come and train you and your staff on how to use Excel more effectively with functions like CountIf and SumIf – give me a call on 020 8203 1774 and visit the website on


Shelley Fishel

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact us

Would you like to talk through your IT Training needs?
Just send through your details and we'll get back to you.