You need to be logged in to view this content. Please Log In. Not a Member? Join Us
Tag: Subtotal
SUM vs. SUBTOTAL Functions
Unlike the SUBTOTAL function, the SUM function is one of the most popular functions in spreadsheet workflow. This popularity is because we often add values in our dataset. However, it falls short in some situations because there is a more efficient way to do things. That’s where SUBTOTAL comes in. In this article, we will look at different situations… Continue reading SUM vs. SUBTOTAL Functions
SUBTOTAL Function
SUBTOTAL is a little-known function in spreadsheet programs. Despite its robustness, it is far less prevalent than functions such as SUM and AVERAGE. Let’s look at what you can do with this function in spreadsheet.com using this template to follow along. Purpose SUBTOTAL returns an aggregate result for a range of cells based on the… Continue reading SUBTOTAL Function