Hello,
I am attempting to write a formula that searches for a text string say "apples" in Column A. If it finds the string, it would count non-blank cells in Columns B-E and return that result. So if Col B-E all were non-blank, result would be "4". If only col B and col E were non-blank, result would be "2". Stuck with not being able to use CountA or DcountA to solve this.

BTW, I setup the dataset so that the text string should only appear once (ie only one row) in Col A

thanks