Jul 29 2021 03:15 PM
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!
Jul 29 2021 08:55 PM
SolutionJul 30 2021 05:52 AM
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.
Jul 29 2021 08:55 PM
SolutionDoes this work for you?
In J2
=SUMPRODUCT(--(F2:H2=G2:I2))
and copy it down.