Related Functions:
The MAXA function returns the largest value from a supplied set of numerical values, while counting text and the logical value FALSE as the value 0 and counting the logical value TRUE as the value 1.
Syntax
=MAXA(num_1,[num_2], … )
Note: Beginning with Excel 2007, you can enter up to 255 number arguments to the function. Excel 2003 would only accept up to 30 number arguments.
Arguments
Argument  Description  

num_1, [num_2], … 
The number arguments are a set of one or more numeric values, or arrays of numeric values, that you want to return the largest value of.

Examples
A  B  C  D  E  

1  Value  Formula  Result  Notes  
2  =MAXA(1,5,10)  10  
3  1  =MAXA(A2,TRUE)  1  TRUE is counted as the value 1  
4  5  FALSE  =MAXA(A3:B3)  0  FALSE is counted as the value 0 
5  10  text  =MAXA(A4:B4)  0  “text” is counted as the value 0 
6  =MAXA(A2:A6)  1  Empty cells A2 and A6 are ignored 
Excel MAX and MAXA Functions
The Excel MAX and MAXA functions are very similar. The difference is, when an argument is supplied to the function as a reference to a cell or an array of cells:
 MAX ignores logical and text values
 MAXA counts the logical value TRUE as 1, the logical value FALSE as 0 and text values as 0
Common Function Error(s)
Problem  What went wrong 

#VALUE!  Occurs if any of the arguments are supplied directly to the function and cannot be recognized as numeric values 