I'm trying to use information from a table to display a count of blank cells based on the type of data in the table. See my example below - I want to count how many of each fruit I'm missing, regardless of their color, and ignoring the apples I do have.
The following formula will almost retrieve the table you want.
Column A is selected to be shown. It is not possible, with the
I've created an example file for you: Counting blank cells based on information in related cell