How to sum every N rows

How to sum every N rows

You can sum tables, columns, but what how do you add up every third row? In this article, we’re going to show you how to sum every n rows using the SUM and the OFFSET functions. The OFFSET function’s ability to return range is the key in this case. Syntax...
How to return an entire row

How to return an entire row

To return an entire row you need to use array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to return an entire...
How to return an entire column

How to return an entire column

To return an entire column you need array returning functions like INDEX or OFFSET. Both of these functions can return arrays, as well as single values, which can be used in other functions like SUM, AVERAGE or even another INDEX or OFFSET. How to return an entire...