## How to calculate the sum of filtered cells

When one wants to hide data from the view, excel has a filter option that filters data in the worksheet. This also data into the filtered and the visible. It…

Skip to content
# Formula

##
How to calculate the sum of filtered cells

##
How to use true and false functions in Excel

##
How to calculate 7 day moving average in Excel

##
How Vlookup to return the max value from multiple hits in Excel

##
How to find max value in range with criteria in Excel

##
Excel min and max in the same formula

##
How to override conditional formatting in Excel

##
Excel formula for percentage decrease and percentage difference

##
Excel formula for quarterly compound interest

##
Excel formula for units of production depreciation

When one wants to hide data from the view, excel has a filter option that filters data in the worksheet. This also data into the filtered and the visible. It…

Comments Off on How to calculate the sum of filtered cells

April 12, 2021

Microsoft Excel is an excellent tool often used to keep track of data and other useful records. Among the various capabilities entailed in excel is the use of function and…

Comments Off on How to use true and false functions in Excel

March 21, 2021

Moving Average is otherwise called running average or rolling average. There is something common about the three different names - moving, running, and rolling. Yes, this type of average has…

Comments Off on How to calculate 7 day moving average in Excel

March 14, 2021

We have several mathematical functions provided in or by Microsoft Excel. Some of these functions are; v-lookup, min, max, mean, mode, and median. They all have their basic function to…

Comments Off on How Vlookup to return the max value from multiple hits in Excel

October 4, 2020

Max, as used in the above statement, is the short form for the word maximum. Maximum is a mathematical function used when we are referring to the value with the…

Comments Off on How to find max value in range with criteria in Excel

September 26, 2020

Whenever we are handling numbers, values, ranges, and figures there is always the need to identify the minimum value of all the values and the maximum values of all the…

Comments Off on Excel min and max in the same formula

September 26, 2020

Formatting is a very crucial aspect of Word editing. You can bold, underline, italicize, set paragraphs, etc. using well-arranged commands and shortcuts. Formatting is also tenable on Excel. There are…

Comments Off on How to override conditional formatting in Excel

August 6, 2020

The analysis involves the calculation of differences between two values. You can also carry out simple percentage operations on your excel spreadsheet. The difference between the two values means change.…

Comments Off on Excel formula for percentage decrease and percentage difference

July 3, 2020

Compound interest is one of the most popular functions in economics and finance. It is a standardized method of cumulating the interest accrued within a given time. In compound interest,…

Comments Off on Excel formula for quarterly compound interest

July 3, 2020

In production, depreciation occurs whenever an asset losses its value due to heavy use. When considering the units of production, depreciation is not calculated based on the duration an asset…

Comments Off on Excel formula for units of production depreciation

June 16, 2020