Dear friends,
I have a question on counting a value with the following example.
example.JPG

as shown in the example, i tried to count "good" with "banana" as criteria but it returns error. especially something is wrong in defining range as B2:K4, if i do B2:B4 it works.....I am confused!

Please suggest

many thanks
Prad