Countifs and do not count zero

[Leda Leong]

Dear all,

as I need to find out the top 3 Remedy in the list item, it show PAINT, FIX AND 0...
but when it comes to zero, it will count a value for zero, but I would like to exclude 0 in my value data
can anybody help, thanks,

my calculation for Column No is =COUNTIFS(A:A,">"&TODAY()-1,F:F,$AC$2,G:G,AE2)

Problem	No	List	No
PAINTP	21	PAINT	16
		FIX	3
		0	1

<colgroup><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"><col width="33" style="width: 25pt; mso-width-source: userset; mso-width-alt: 1206;"><col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"><col width="50" style="width: 38pt; mso-width-source: userset; mso-width-alt: 1828;"><tbody>
</tbody>

DATE	J-Day	MONTH	Status 狀態	Problem	Remedy
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	DUPLICATE	PAINTP	0
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	FIX
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	ZR-OTHER
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	FIX
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	PAINT
27-Sep	270	9	COMP	PAINTP	FIX

<colgroup><col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;"> <col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;"> <col width="97" style="width: 73pt; mso-width-source: userset; mso-width-alt: 3547;"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3510;"> <tbody>
</tbody>

 

[Cross Terrier]

The simplest way seems to be to add another criterion to your COUNTIFS:
=COUNTIFS(A:A,">"&TODAY()-1,F:F,$AC$2,G:G,AE2,D:D,"COMP")