Using COUNT and IF (multiple criteria) to calculate

[mimccoy]

Hello,

I'm straggling to put COUNT of the row which has value (ignoring zero or blank cells) and IF (two or more criteria) together.

Example. I try to count the column C ignoring zero cells based on the criteria the column A as "Apple", the following formulas works.

=SUM(IF(IF(C1:C10>0,A1:A10)="Apple",1,0))

However how can I add one more criteria which in the column B which indicate the rank of the product "A" to "C"
As result, "Apple" A rank 1, "Apple" B rank 2, "Apple" C rank 0

1 A B C
2 Apple A 3,000
3 Apple B 800
4 Orange A 0
5 Apple C 0
6 Orange B 2,000
7 Apple B 600

Appreciate your help!!!

[AliGW]

Have you tried COUNTIFS?

[63falcondude]

I don't understand what results you are expecting. It will help to see a small representative sample of your data along with the desired results (which you can enter manually).

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

[63falcondude]

Ooh, I think that I get it. Try this:

=COUNTIFS(A:A,"Apple",B:B,"A",C:C,"<>0")

You can adjust "Apple" and "A" accordingly.