I'm currently using the following formula that I found on Google. It counts how many rows have value "Car" in column C:C OR have value 1 in column F:F. The formula seems to work great:
=SUMPRODUCT(N(('Form responses'!C:C="Car")+('Form responses'!F:F=1)>0))
I now need to do the same count, but this time only count rows where ((Column C:C has value Car OR column F:F has value 1) AND column B:B has a date within the last two weeks)
Please notice the nesting. First the OR rule is applied, and then the AND.
Many thanks in advance!
Bookmarks