COUNTIF function giving Type Mismatch error

[Utzja1]

Hi, I'm sure this is a simple problem of syntax but I'm trying to learn how to use this function so I can apply it in a larger context within a worksheet. I have the following code:

Please Login or Register  to view this content.

In short, the User enters SUB in Column B to indicate that the previous group is to be subtotaled. Eventually, the code will give the user the ability to add a new group of bars, and to do that, I have to know how many groups already exist. I was hoping to use the COUNTIF function to find the number of times the "SUB" keyword has been entered. To simplify things, I was naming the range and then using it as one of the arguments in the COUNTIF function, but it gives me a Type Mismatch error every time. The arguments for COUNTIF are range and criteria, and it should return a Double. I don't see any obvious problems in my syntax but it bombs out every time I run it.

Thanks for your time!

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Utzja1]

The problem was in how I was calling the range. the syntax should read:

Please Login or Register  to view this content.

[zbor]

Thank you for sharing solution.

This should also work:

Please Login or Register  to view this content.