Passing arguments in COUNTIF function

**abduljaleel.mca** · 02-13-2013, 05:56 AM

Hi,

I need to use countif function for column A15 to C15 to count the number of occurrences using macro but the following code is not working
I have data in 3 columns (A-C) up to 15 rows.

Please Login or Register  to view this content.

x and z values will change project to project so I need to pass this as an argument.

Please help me.

**Excel4Everything** · 02-13-2013, 07:36 AM

How about:

Please Login or Register  to view this content.

**abduljaleel.mca** · 02-13-2013, 11:03 AM

Hi,

Thanks for your reply.

Now I am getting an error - "error 13 type mismatch" after using your code.

**Excel4Everything** · 02-14-2013, 05:57 AM

Sorry, you need to convert numbers to strings. Try this:

Please Login or Register  to view this content.

**abduljaleel.mca** · 02-14-2013, 08:15 AM

Hi,

I used your first code with some little modification and it is working fine now. Please see below.

ActiveCell.FormulaR1C1 = "=COUNTIF(R1C1:R" & x & "C" & Z & "," & i & ")"

Thank you so much for your help.