You can perform calculations on a vast collection of values within a single cell, using an array formula that produces a single value as a result.