indentify status text in ne colum and count in another if

[Slowfish]

Hi!

I know next to nothing about vb programming, but nevertheless i have tried to compile a function it although contains an error which i can't identify.

Please Login or Register  to view this content.

Hope someone can and will help... thx

[StevenM]

You have two "for"s and only one "next". You need a next for each for.

Please Login or Register  to view this content.

Also, you are using "cell" twice, once as part of varRange, and once as part of subRange. You can solve this with cell1 and cell2.

[tigertiger]

Hi!

I know next to nothing about vb programming, but nevertheless i have tried to compile a function it although contains an error which i can't identify.
Hope someone can and will help... thx

there is only one cell variable that make confusing (a share variable)

May be

Please Login or Register  to view this content.

[Slowfish]

Thanks... I still really dont know what to do. I just derived and compiled the function based on what i have seen in other vb functions, but clearly I haven't understood a fraction of what is needed. Can you help me rewrite it? plz...

[Slowfish]

Thanks tiger, but it still gives me an error in the 4th line closest to the end:

Next If Cell2 .Text = strText Then Countcolorif = Countcolorif + 1

[StevenM]

P.S. I'm not for sure what you want, but the syntax here is correct.

Please Login or Register  to view this content.

[StevenM]

it still gives me an error in the 4th line closest to the end:

Next If Cell2 .Text = strText Then Countcolorif = Countcolorif + 1

What is Countcolorif?

Please Login or Register  to view this content.

Here Countcoloriftext is the function which returns a long variable.

[Slowfish]

Thanks for input... StevenM yours almost worked.

I have attached an example:

example.xlsm

I need to count the number of active/inactive subscriptions.

[StevenM]

Well the answers are:

Active & A = 9, because 3 actives * 3 As = 9
Active & B = 6, because 3 actives * 2 Bs = 6
Inactive & A = 6, because 2 inactives * 3 As = 6
Inactive & B = 4, because 2 inactive * 2 Bs = 4

So where is the problem?

[tigertiger]

Thanks for input... StevenM yours almost worked.

I have attached an example:

Attachment 151933

I need to count the number of active/inactive subscriptions.

Why don't use the COUNTIFS function, like this
=+COUNTIFS($B$11:$B$15,E$5,$D$11:$D$15,$D6)
for E6
copy it for the last cells in E and F column

[Slowfish]

Lolz Tigertiger! This is second time today you have made my live simpler Thanks a lot...

[StevenM]

How about?

Please Login or Register  to view this content.