Hi,

Use the array formula,

=MAX(IF(ISNUMBER(BI100:BI3000),BI100:BI3000,-1E+100))

Confirm with CTRL-SHIFT-ENTER

Regards,
B. R. Ramachandran

"nastech" wrote:

Hi, trying to find a maximum value in a column.
Guesse errors would need to take into account cells that have headerl lines
with text
(need to do numbers only?)

Tried: =IF(ISNUMBER(BI100:BI3000),MAX(BI100:BI3000))
but not quite there yet