Monthly Archives: March 2014

Data ==> Subtotal

Posted on March 28, 2014 by

How to insert thousands of rows for each change in item in a column?  And then give a subtotal of each item? Long long time ago (>10years) when I was only an Excel newbie, a friend asked for help.  She … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

SUM vs. SUBTOTAL

Posted on March 26, 2014 by

How to SUM a range but ignores SUM result in between?, i.e. How to get a Grand Total with SubTotals in between? How to SUM but ignores hidden cells or filtered cells? SUM could be the most popular function used in … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , | 8 Comments

SUM ignoring errors in the range

Posted on March 22, 2014 by

Different ways in getting sum of a range with “Error” Thanks to the comments made by a friend, I would like to share a few workarounds to ignore errors with SUM. 1) Use a helper column This would be an … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

Excel Basic – Sum vs. “+”

Posted on March 18, 2014 by

+ – x / would be the four basic operators you learned in Excel basic.  When you learned to use SUM instead of +, did you ask yourself or your teacher why? 1) SUM is much easier to input and … Continue reading →

Rate this:

Posted in Excel Basic, Formula | Tagged | 9 Comments

Paint the Lily

Posted on March 15, 2014 by

Well, this is not an Excel post.  This is something about Visual Presentation at a glance, so I think it’s sort of related to Excel.  🙂 One day, I visited a Japanese Fast Food Restaurant and saw the above sticker … Continue reading →

Rate this:

Posted in Format, General | Tagged | 1 Comment

Dynamic Dependent Dropdown by Data Validation

Posted on March 15, 2014 by

So many D. 😀 This is a continuation of the previous post: Not all teachers are eligible to all classes.  e.g. only Iris and David are eligible to deliver Class F, would it be feasible to have only Iris and … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

Dynamic Dropdown – Least hours assigned always on the top

Posted on March 7, 2014 by

How to use Data Validation to show a dynamic drop-down list to facilitate job allocation problem? I learned about using Data Validation long time ago.  It’s quite handy and useful when you want to restrict user to enter items only … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 2 Comments