Paul Wherly

Tip: CountIF and SumIF in Excel

Category: IT Quick Tips, Microsoft 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: =SumIF 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 […]

Read More

Contact us

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

More