Mister Bear
New Member
I am working on a 44 columns (P4:BG4) on a worksheet for monitoring daily sales of sales agents. It is company policy to call the attention of an agent once he has zero "0" sales for 2 consecutive days. On the next column (BH4) I would like to put in a formula that can trace two consecutive zeros. To count the days with no sales, I used:
=countif(p4:bg4,0)
which worked fine to give me the total number of no sales days. But now I have been asked to count the number of CONSECUTIVE DAYS with no sales. Can you please help me?
=countif(p4:bg4,0)
which worked fine to give me the total number of no sales days. But now I have been asked to count the number of CONSECUTIVE DAYS with no sales. Can you please help me?