Excel SumIf function

Published: Wed, 06/27/12

The Excel Expert

Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users

Excel SumIf function- 2012-05-08 08:03:43-04

Using Sumif One of the more useful (but lesser known functions in Excel is the SumIF function. This has been available in most versions (unlike the SumIFs function – which I am going to cover in another post. So what does it do? Let me give you a couple of scenarios: You have a list [...]
Read more...

Countif function- 2012-05-08 08:16:29-04

Countif Function Again, Excel Countif is a function (not always so well known in Excel that has many uses. Let me give you a couple of examples.. You want to count the number of Nos or Yeses in a list… You want to count the number of items in a list that are less than [...]
Read more...

Excel Pivot Table| Excel pivot table tutorial – create your first pivot table- 2012-05-14 06:53:48-04

How to create pivot tables If you are working with any sort of lists in Excel and you want to be able to extract meaningful data out of it, a key skill you should have in your toolbox is how to create a pivot table. Essentially a pivot table allows you to move around the [...]
Read more...