increment and return to "0"

[jarhead58]

Hey all,

I'm trying to use this to increment a number if certain cells equal other cells and then if the range F13:T21 <> the criteria, reset to "0". Am I on the right track? I know it's not working the way it is now. TIA

=MOD(COUNTA(F13:T21,N2:Q2,+COUNTIFS(F13:T21,I2:K2))

 

[jarhead58]

Nevermind, just answered my own question!!

 

[jarhead58]

Ok, so I thought I had it!! I still need help! TIA

=COUNTIFS(F13:T21,I2:K2)+COUNTIFS(F13:T21,N2:Q2)+1