Hi,
I want to create a formula that counts the appearance of a word in a continuous list over the last weeks:
In my example, this would be how often did we have apple during the last 4 weeks. I tried
but it is not working. Can anyone help me please?
I want to create a formula that counts the appearance of a word in a continuous list over the last weeks:
In my example, this would be how often did we have apple during the last 4 weeks. I tried
VBA Code:
=COUNTIFS(A1:A11;">="&TODAY()-28;B1:D11;F4)
but it is not working. Can anyone help me please?