I'm learning about this feature of data validation. Two columns, Colors, and Shapes. Using two drop downs to select a shape and color, and Countifs sums the rows that match both criteria. My question was about dealing with making a null selection in one of the drop downs, but the Countifs function still counts the other. In other words, select a color but no shape, and the countifs still counts all the matching colors. Can this be done in the countifs formula or does it require some coding?