CountIfs - Wertewechsel zählen (Counting Changes in Values)

[freakyOne]

Good Morning sweeties,

ok here is my problem.
In column A i have different values which is first repeated for some cells, then it changes one time and then it repeats again.
A1 - 15, A2 - 15, A3 - 2, A4 - 2, A5 - 2, A6 - 36...

and in column H there is either NS, SS or FS as values.

Now i want to count for i.e. all rows where is standing NS in column H and if the value in column A is different from the value in the cell one row above (A2 different than A1)

In the example above it would count A3 - 2 and A6 - 36

My try was:

Please Login or Register  to view this content.

It doesnt work, invalid variable type...

Can anyone help?

Thank ya :*

[jolivanes]

Please Login or Register  to view this content.

[freakyOne]

It doesnt work

Please Login or Register  to view this content.

(the column changed from H to F)

Errormessage:
Runtime Error 1004

software- or objectbased error (i hope the translate doesnt destroy the understanding completely)

thanks

ps: if i use the code you give me up there i get a message Box with the value "0" (ofcourse cause in column H is no "NS" anymore)

[jolivanes]

Yes, you have changed the "H" Column to the "F" Column but not the offsets.
You cannot go 7 left, c.Offset(,-7) from Column 5, Column F. You need to change the -7 to a -5
Let us know if that works.
Have good time at the Weihnachtsmarkt in Celle

[jolivanes]

Did it work?

[freakyOne]

sry, wasnt at work until now,

yes it works now. thank you all for your help. :*

[AliGW]

In future, please ensure that your thread titles are in English. Thanks.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.