Monthly Archives: March 2014

Data ==> Subtotal

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

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 , | 9 Comments

SUM ignoring errors in the range

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. “+”

+ – 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

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

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

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