Tag Archives: Sample File

An example of using Solver for a causal problem in daily life

Posted on March 5, 2016 by MF

This post is intended to give you an example of using Solver in Excel to solve a causal problem in daily life – buying postal stamps.  Don’t consider it a tutorial. 😛 Have you ever heard of Solver in Excel? I think … Continue reading →

Rate this:

Posted in General | Tagged , | 1 Comment

A trick to SUM visible columns only (without VBA)

Posted on August 29, 2015 by MF

We know that SUBTOTAL allows us to perform some basics functions like SUM, COUNT, AVERAGE, etc.  that apply to visible rows only.  However, there is no similar function for visible columns only. If we need to SUM visible columns only, we will need … Continue reading →

Rate this:

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

SUM Time in the end of text strings

Posted on July 25, 2015 by MF

Did you encounter a task like this?  I did.  Actually it is not as difficult as you may expect.  It could be done in just a minute IF the data is not too bad, like the one shown above. I … Continue reading →

Rate this:

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

=SUM(‘???’!C3) Is it a valid formula?? No. It is magical indeed!

Posted on July 11, 2015 by MF

This is about using wildcards in referencing cells on other worksheets. If you know the basic rule about naming a worksheet, you should know that we cannot use ? or * in any part of a worksheet’s name.  So there … Continue reading →

Rate this:

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