Area function is a very significant function when it comes to determine how many references have been selected in the formula.
Let’s see how to use Area function in excel.
Area function is used to find the number of selected references in a range. Range could be named range or manually selected range.
Area (B1:B2,C2:C6:,G5) will return 3
Area (G5) will return 1
Area (C2:C6) will return 1
Use comma to separate multiple ranges in area function.
Hope this helped.