Does anyone have a real-world use for the areas function?

AREAS((B2:B3,C4:C5,D6:D7)) produces 3, the number of elements in the list but what now?

Index takes an optional areas-index argument but it's hard to see a use for that as well.

You must log in to answer this question.

Browse other questions tagged .