VBA Application CountIfs code

**spyac** · 04-23-2019, 04:37 PM

I am currently trying to count #N/A in a column based off of 2 criteria in a different column. The excel formula I wrote counts them correctly

Formula:

Please Login or Register  to view this content.

I adjusted code to also count and notify the user if #N/A errors existed before continuing to process the file. The code runs Ok but always creates the message box even when the actual count is zero. The count of #N/A is always in Column "AS" and the criteria is always in Column "V" using the text terms CSA Or GPA as the criteria If either one exists in Column V with a matching #N/A in column AS, then count 1 for each instance. I must have the code or format wrong. Can you help or offer a better way. Thanks

Please Login or Register  to view this content.

**Keebellah** · 04-23-2019, 04:45 PM

Instead of the logical bYes you should make it an integer or a long integer
This will reflect the number of time the N/A exists then if the result is > 0 then show the messagebox

**protonLeah** · 04-23-2019, 04:56 PM

When numeric types are converted to Boolean values, 0 becomes False and all other values become True
Since bYes is the sum of several counts, > 0 --> True
However, you never check the status of bYes once the sum is computed you just immediately execut the msg box line no matter what. Use:

If bYes, then MsgBox

**Keebellah** · 04-23-2019, 05:08 PM

True, also good

**spyac** · 04-24-2019, 08:22 PM

Thank You for the help It worked out well

VBA Application CountIfs code

LinkBack

Thread Tools

Rate This Thread

Display

VBA Application CountIfs code

Re: VBA Application CountIfs code

Re: VBA Application CountIfs code

Re: VBA Application CountIfs code

Re: VBA Application CountIfs code

Thread Information

Users Browsing this Thread

Similar Threads

Application.WorksheetFunction.CountIfs dates

email code works but while running as application from another code selects whole sheet

[SOLVED] Application.WorksheetFunction.CountIfs Issue - Equal or Greater Than

[SOLVED] VBA code to change the application.username and application.userinitials

more efficient way to do for-loop using application.worksheetfunction.countifs

[SOLVED] worksheetfunction countifs, counting down and across, application defined error

error trying to use "Application.WorksheetFunction.Sum(CountIfs"....in vba

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions