LoveCandle wrote...
What is the benifit of the worksheet function AREAS?

How can we use it with other functions?
....

Homework?

AREAS is one of the less useful information functions. It's only use is
returning the number of areas in a range reference, and there's little
or no need for that since it's unnecessary in functions that can handle
general range references (like SUM), and it's unnecessary to deal with
functions that can handle only single area ranges (like SUMIF) since
one may use INDEX(Range,0,0,1) to refer to the first area of a general
range reference.

It ranks right up there with INFO, both of which are more useful than
POWER or CONCATENATE.