 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2006count errors
XL 2002 SP3 Win XP HE SP1 Follow-up to: microsoft.public.excel How do I count errors #N/A in column A that has both errors and proper values in some of its rows? I am trying a countif but struggling w/ the error part e.g. isna or iserror, etc. tx. How about: =COUNTIF(A:A,"#n/a") > XL 2002 SP3 > Win XP HE SP1 [quoted text clipped - 8 lines] > > tx.  SignatureDave Peterson sure i can do that but it's not optimal since the error "code" could be different.... > How about: > [quoted text clipped - 12 lines] >> >> tx. I was confused by your post. I thought you wanted to only count N/A errors: =SUMPRODUCT(--ISERROR(A1:A100)) Extend the range, but don't use the whole column. > sure i can do that but it's not optimal since the error "code" could be > different.... [quoted text clipped - 15 lines] > >> > >> tx. SignatureDave Peterson yes that's it, as if Biff's post. thanks! > I was confused by your post. I thought you wanted to only count N/A errors: > [quoted text clipped - 21 lines] >>>> >>>> tx. Try this: =SUMPRODUCT(--(ISNA(A1:A100))) That will only count #N/A errors. It won't count #Value! or #REF! or #NUM! etc. If you want to count ALL errors: =SUMPRODUCT(--(ISERROR(A1:A100))) Biff > XL 2002 SP3 > Win XP HE SP1 [quoted text clipped - 8 lines] > > tx. That's it. Thanks > Try this: > [quoted text clipped - 21 lines] >> >> tx. You're welcome! Biff > That's it. Thanks > [quoted text clipped - 23 lines] >>> >>> tx. =COUNTIF(A1:A100,#N/A) > XL 2002 SP3 > Win XP HE SP1 [quoted text clipped - 8 lines] > > tx.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.