Hello,

I have two colums,

In the first column you have date and second column you have either "Order Successful" or "Order unSuccessful" and are entered everyday.

Now for Example if I changed the order status from Unsuccessful to Successful, I want a formula, where it only counts the "changed" values that are changed afterwards.

I hope I am clear. I just want to count the cells that had their statuses (AFTERWARDS NOT INITIALLY) changed at the end of a certain date, either today or within the past 3 days.