I'm looking for a formula to add the number of times an occurrence happens. Some times the value will be blank. In the example I've attached I showed what I would like to see for results (I4). As you can see Banana shows up 6 times but only has values for 4. I'm not looking for a total just a count of the number of times Banana has a value
Any help would be appreciated
Bookmarks