Compare and Count Two Columns, Then Filter Out 100 and 0

[pbundrant]

Hello,

I'm trying to find a way/formula to compare the values in MAR columns to FEB column and if they match to count them and not "100"and "0."

These are percentage complete. Need to find the 'stagnant' ones.
Can anyone help? Been trying CountIf(S). Can't get it to work.
FEB MAR
55 55
0 0
65 65
95 95
100 100
100 100
95 100
0 0
0 0
100 100
95 100
55 55
55 55
55 55

I should get a count of 6 with these numbers.

TYIA,

Patty

[stnkynts]

THere is probably a better way to do this with a formula. This is all I could come up with at the moment:

Sub Count_Differences()
Dim rCell As Range
Dim iCount As Long

iCount = 0

For Each rCell In Range("A1:A" & Range("A" & Rows.Count).End(xlUp).Row)
    If rCell.Value <> "0" And rCell.Value <> "100" Then
        If rCell.Value <> rCell.Offset(0, 1).Value Then
            iCount = iCount + 1
        End If
    End If
Next rCell

MsgBox (iCount)

End Sub

[pbundrant]

Thank you stnkynts.
Can you tell me how I would call it out on the sheet?

Patty

[stnkynts]

Can you tell me how I would call it out on the sheet?

I don't understand what you mean. Are you asking how you would create a command button and assign the macro to it, how to assign a shortcut key to it, how to run a macro, or somthing else?

[stnkynts]

Can you tell me how I would call it out on the sheet?

I don't understand what you mean. Are you asking how you would create a command button and assign the macro to it, how to assign a shortcut key to it, how to run a macro, or somthing else?

[martindwilson]

with a formula
=SUMPRODUCT((A2:A15=B2:B15)*(A2:A15<>0)*(A2:A15<>100))
or slightly shorter
=SUMPRODUCT((A2:A15=B2:B15)*(MOD(A2:A15,100)<>0))

[pbundrant]

Thanks you MARTINDWILSON!!
It worked :D
=SUMPRODUCT((D2:D1411=E2:E1411)*(MOD(D2:D1411,100)<>0))

Thank you for your help as well stnkynts. I meant calling the sub out in a cell, =Count_Differences(????).

Have a great day!
Patty

[pbundrant]

This is what I've been trying, doesn't work:

=SUMPRODUCT((D2:D1411=E2:E1411)*1, --(E2:E1411,"<>"&0),--(E2:E1411,"<>"&100))

they are columns D & E.

I will try what you posted Martin, thank you.

Patty