Hi,
Trying to figure out lost/new business. Looking for customers who have not purchased in 13 months Jan23-Jan24 but did purchase in Feb24.
Formula:
=COUNTIFS(B2:N2,"<1")&(COUNTIFS(O2:O2,">=0")))
I can't seem to upload or paste.....
Excel Question.JPG
Bookmarks