Let's look at the syntax.
Well, not a complicated function. An area is a range of contiguous cells or a single cell. For example AREAS(B1) = 1 and AREAS(B1:B10) =1. Please note whether the cell contains a value or not will not change the outcome of the results.
AREAS(reference)
If we use multiple reference then the result will count of the references, for example AREAS((B2,B3,B11)) = 3.
There is another use of this function, which actually uses the "
contiguous" part.
There are two lists, list1 and list2 in the worksheet. In this case AREAS will give the number of overlapping cells.
AREAS(list1 list2) = 6
As always love to have your comments.
ExpiresDefault access plus 1 year
Nice post. I was checking constantly this blog and I am impressed! Extremely helpful information specially the last part I care for such info a lot. I was seeking this particular information for a very long time. Thank you and good luck.
ReplyDeleteexcel vba courses london