VideoPhoto

Showing posts with label summing. Show all posts
Showing posts with label summing. Show all posts

11 November, 2021

Array formulas summarize tables with multiple conditions

Let's assume that you are using Excel table for recording sales of some products by several agents. From time time you need to check how your business is doing.

The table is getting larger and larger. I set its size arbitrarily to 1000 rows, but this is up to the user needs. Here is just its small fragment: