On Wed, 14 Mar 2012 08:48:56 -0700 (PDT), Steve wrote:

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.

Any ideas? Thanks so much!


If you have Excel 2007 or later, you can use COUNTIFS:

=COUNTIFS(A:A,"apple",B:B,"<"&"")

If you have an earlier version of Excel, use:

=SUMPRODUCT((A1:A1000="apple")*(B1:B1000<""))