Hello. I'm looking for a variation of the formula Countif tht will operate in a similar fashion to the Sumif.
In column A I have various categories. In column B I have either blank cells or numbers. I need to scan column A to indentify a category (Apple for example), and then COUNT the non-blank cells for Apple in column B.