Assume Range A1:B15

The Function to calculate number of cells containing all types of errors:
€¢ {=SUM(IF(ISERROR(A1:B15),1))}

The Function to calculate number of cells containing error type #N/A:
€¢ {=SUM(IF(ISNA(A1:B15),1))}

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Peter Bircher" wrote:

Hi all

I need to be able to detect whether a cell contains #N/A or alternatively a
number

If Cells(I - 1, HighestPColumnnumber).Number Then . . .

--
Thanks in anticipation

Peter Simonotti-Bircher

SA MEDICAL EQUIPMENT
Tel : +27 31 266 9422
Cell : +27 83 233 1628 - Peter
+27 82 555 1192 - Marcelline
Email: