Category: Formulas – combined functions

We did see who we can get total of a column for a certain month in certain year using SUMIFS. SUMIFS got a sister function,...

The powerful function If can already do a lot of tricks, but we can for sure do more when we use it with AND or...

One of the power of combining functions in one cell is using the best of these functions An example is here, OFFSET + MATCH will...

Found this in an old file while doing some digital cleaning This will show you how you can easily count how many times a letter...

You must already know that when you press Enter after you modify a cell, the cell content will be saved and you jump down to...

Get total number of days per month This was a question from one of my friends, This set of formulas will calculate how many days...

I need that more often than I thought It is basically extract the full workbook name that we are in, with no folders, and with...