if a date is before an appointment, then count certain words in a different range
I need to count how many entries with certain words are in the range B1:G10 if the date in column A is before the entry in I1. My formula in I2
=IF(@A:A<I1;COUNTIF(B2:G10,”*Natz*”)+COUNTIF(B2:G10,”*Verd*”)+COUNTIF(B2:G10,”*City*”)+COUNTIF (B2:G10; “*Hint*”); “nothing”)
is wrong, it outputs all values. The result in I3 is also wrong when I want to search with
=IF(@A:A>I1;COUNTIF(B2:G10,”*Natz*”)+COUNTIF(B2:G10,”*Verd*”)+COUNTIF(B2:G10,”*City*”)+COUNTIF (B2:G10; “*Hint*”); “nothing”)
all entries after the appointment in I1. Where is my mistake? For answers, I would be very thankful!
I need to count how many entries with certain words are in the range B1:G10 if the date in column A is before the entry in I1. My formula in I2=IF(@A:A<I1;COUNTIF(B2:G10,”*Natz*”)+COUNTIF(B2:G10,”*Verd*”)+COUNTIF(B2:G10,”*City*”)+COUNTIF (B2:G10; “*Hint*”); “nothing”)is wrong, it outputs all values. The result in I3 is also wrong when I want to search with=IF(@A:A>I1;COUNTIF(B2:G10,”*Natz*”)+COUNTIF(B2:G10,”*Verd*”)+COUNTIF(B2:G10,”*City*”)+COUNTIF (B2:G10; “*Hint*”); “nothing”)all entries after the appointment in I1. Where is my mistake? For answers, I would be very thankful! Read More
