Thread: Counting Values amongst #N/As
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NBVC[_81_] NBVC[_81_] is offline
external usenet poster
  
Posts: 1
Default Counting Values amongst #N/As

=Countif(A1:A100,"#N/A") to count #N/A

and

=Countif(A1:A100,"<#N/A") to count values other than "#N/A"


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113005

Reply With QuoteReply With Quote