I figured it was time for another Excel tutorial. This time I’m looking at the IF function. IF is really just like it would be in a sentence. If A=B then “something”, else “something else”. The syntax is :

=if(logical_test,value_if_true,value_if_false)

Check out the video for more.

Have you ever had a spreadsheet with 150 lines of data and you need to know how many times “Red” appears in a cell? The COUNTIF function in Excel is for you. Here is a run through of how you can use this in your spreadsheets.

Welcome to my first, of hopefully many, tutorial on how to use Excel’s SUMIF() function. My first ever YouTube video too – how very geeky. This function works the same in both Excel 2003 and Excel 2007.