Question about Computer Utilities & Maintenance

1 Answer

Excel formula I want to create a countif formula based on different criteria been matched eg: =IF(A3='Audit Exception Register'!B:B, COUNTIF('Audit Exception Register'!P:P,Y), 0)

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

  • Contributor
  • 51 Answers

The IF() is the wrong one to use. Use "Iif()", as in:

=IiF(A3='Audit Exception Register'!B:B, COUNTIF('Audit Exception Register'!P:P,Y), 0)

See:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=799

Caveat about using Iif(), one that doesn't probably apply in this case, but keep it in mind: Don't use Iif when trying to return the values of "real" objects. Examples of "non-real" objects in the VB/A world are:

String
Integer, Double, etc... all the numeric "objects"
Boolean

These are fine to use in IIf() statements. If however you will be returning some value that is part of an object, as in:

Iif(x=2, myObject.getSomeVal(), 0)

You run the very real risk that is myObject is null, your program will simply stop running. Iif() will NOT return a null error/exception; it will in fact just stop. This is a bug in the VB interpreter and/or in the Iif() function itself.

I am referring here to classic VBA (ie, pre-VB dot-Net). How .NET handles such cases, I don't know.

Posted on Mar 07, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I have lost a key for gofit platinum and tried contacting the company but no luck


Hi, Anonymous, try downloading Belarc Advisor Free Personal PC Audit Version 8 4 . It creates a webpage document that shows all the information related to your system: OS, installed programs and serials and innard specs.

May 24, 2015 | Platinum Computer Utilities & Maintenance

1 Answer

Excel formulas


Below is the formula for "2". The logic should be obvious from this so you can adapt for "1" or a combination of 1 and 2. This need to be written as one long formula so I have pasted it in to this reply so you can do a copy and paste into your spreadsheet. Sorry its not very readable in this form but you could paste into word so you can break it down and examine structure.

=IF(OR((AND(Sheet3!A12="WA",OR(Sheet3!AH2="Lewis",Sheet3!AH2="Pacific",Sheet3!AH2="Wahkiakum"))),(AND(Sheet3!A12="OR",OR(Sheet3!AH2="Clackmas",Sheet3!AH2="Multnomah",Sheet3!AH2="Washington")))),"X"," ")

Aug 18, 2009 | Microsoft Office Excel 2007 Full Version...

1 Answer

Link in excel 2007


right click on any cell then select hyperlink option from the list then a dialog box will appear infront of you
in left hand side pane there is option place in this document click on that then in right hand side pane select sheet 2 or sheet 3 whichever you want...
or if you want to open any other file so use existing file...option

Jul 01, 2009 | Computer Utilities & Maintenance

2 Answers

Covert lotus notes address book "names.nsf" to an excel file


I just stumbled on this one. Actually it's EASY! Open up your contacts list in Notes, go to the File menu, choose export. You can pick either "Structured Text", "Tabular Text", or "Comma Separated Value". All of these import well into either of those programs.

Apr 18, 2009 | Computer Utilities & Maintenance

1 Answer

EMC DiskXtender file duplication


Yes you can. In DX terms this is just a "move". When the file is removed from its original location it leaves behind a 1k file tag. This is called a "purge". You can setup the rules for each of these operations with different criteria.

Jan 28, 2009 | Legato EMC DiskXtender 2000 (mkt-001400)

1 Answer

Microsoft works 7.0


From the Microsoft Office 2003 Web site:

Excel 2000 or later versions cannot directly open files created in Microsoft Works version 3.0 or later. To open a Works file in Excel, first open it in Works and use the Save As command to convert it to one of the file formats listed below. Then close the Works file and open the converted version in Excel.
  • Works for Windows 2.0/Works for DOS SS
  • Excel SS
  • Lotus 1-2-3
To open a Microsoft Works database file in Excel, first save the file in Microsoft Works as a dBASE file, and then open the dBASE file in Excel.

Feb 11, 2008 | Computer Utilities & Maintenance

1 Answer

Excel formula with example


Go to fx and click on it. a small window will open asking you what formula would you like to apply. click on the formula, then select your numbers and hit OK. you are done.

Nov 17, 2007 | Computer Utilities & Maintenance

1 Answer

How to convert numericals in to words.


You will have to delve into some Visual Basic within Excel:

See this KB article from MS:

http://support.microsoft.com/kb/213360

Oct 22, 2007 | Computer Utilities & Maintenance

Not finding what you are looking for?

Open Questions:

0 Answers

When we used U+S+A/ Nortan Internet Security Customer Number? USA1-877-778-89-69Nortan Antivirus support Helpline Number, Nortan Customer support Telephone Number.Nortan Helpdesk number,Nortan Tech support Telephone number .D.I.A.L 1-877-778-89-69Nortan Inetrnet Security Customer Number is offers superlative antivirus support phone number by our best tech qualified guys working for Nortan Support Phone Number. Norton Antivirus Support Phone Number, Norton Antivirus Customer Service Phone Number, Norton Antivirus Tech Support Phone Number, Nortan Antivirus support Helpline Number, Nortan Customer support Telephone Number.Nortan Helpdesk number,Nortan Tech support Telephone number,Nortan Antivirus Tech Support Number,Nortan Internet Security Customer Number,Nortan Customer Service Technical Support Number. Norton Antivirus Support Phone Number, Norton Antivirus Customer Service Phone Number, Norton Antivirus Tech Support Phone Number, Nortan Antivirus support Helpline Number, Nortan Customer support Telephone Number.Nortan Helpdesk number,Nortan Tech support Telephone number,Nortan Antivirus Tech Support Number,Nortan Internet Security Customer Number,Nortan Customer Service Technical Support Number. Norton Antivirus Support Phone Number, Norton Antivirus Customer Service Phone Number, Norton Antivirus Tech Support Phone Number, Nortan Antivirus support Helpline Number, Nortan Customer support Telephone Number.Nortan Helpdesk number,Nortan Tech support Telephone number,Nortan Antivirus Tech Support Number,Nortan Internet Security Customer Number,Nortan Customer Service Technical Support Number. Norton Antivirus Support Phone Number, Norton Antivirus Customer Service Phone Number, Norton Antivirus Tech Support Phone Number, Nortan Antivirus support Helpline Number, Nortan Customer support Telephone Number.Nortan Helpdesk number,Nortan Tech support Telephone number,Nortan Antivirus Tech Support Number,Nortan Internet Security Customer Number,Nortan Customer Service Technical Support Number. Norton Antivirus Support Phone Number, Norton Antivirus Customer Service Phone Number, Norton Antivirus Tech Support Phone Number, Nortan Antivirus support Helpline Number, Nortan Customer support Telephone Number.Nortan Helpdesk number,Nortan Tech support Telephone number,Nortan Antivirus Tech Support Number,Nortan Internet Security Customer Number,Nortan Customer Service Technical Support Number.

Dec 02, 2016 | Internet Computer Utilities & Maintenance

Computer Utilities & Maintenance Logo

Related Topics:

155 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computer Utilities & Maintenance Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Computer Utility and Maintenance Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...