SOLVED

Formula help needed

Copper Contributor

Below I have some sales reps and the total accounts each one manages. I'm trying to come up with a formula in Column J showing the number of months where their totals remains the same (i.e. no growth). For example, the rep in the first row didn't gain any new accounts in June, which would be 1 month without any growth. Is there an IF statement or something I can use to quickly measure this? Thanks in advance!

 

dmoney7612_1-1627596373656.png

 

 

3 Replies
best response confirmed by dmoney7612 (Copper Contributor)
Solution

@dmoney7612 

Does this work for you?

 

In J2

=SUMPRODUCT(--(F2:H2=G2:I2))

and copy it down.

@Subodh_Tiwari_sktneer This works well. Appreciate it

You're welcome @dmoney7612! Glad it worked as desired.

 

Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.

1 best response

Accepted Solutions
best response confirmed by dmoney7612 (Copper Contributor)
Solution

@dmoney7612 

Does this work for you?

 

In J2

=SUMPRODUCT(--(F2:H2=G2:I2))

and copy it down.

View solution in original post