subtotal with countif

[faraz502]

I NEED SUbtotal with countif in Column D2 When i filtered in columnA give me 0 count in cell d2.


ColumnA[TABLE="width: 257"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]ColumnB[/TD]
[TD]ColumnC[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Platinum[/TD]
[TD]South-1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Platinum[/TD]
[TD]South-1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]Silver[/TD]
[TD]South-2[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

 

[DanteAmor]

You can comment on what you want to count, what the condition is and what you expect from the result.

 

[faraz502]

You can comment on what you want to count, what the condition is and what you expect from the result.

I need count how many zero in column C when i chose Silver in column A.

I use Below mention formula but this formula count all zero from column C. <example: formula Taken all this Zero's (10, 20, 30,0.89, 0.79)>


=SUMPRODUCT(SUBTOTAL(3,OFFSET(C2:C1677,ROW(C2:C1677)-MIN(ROW(C2:C1677)),,1)),ISNUMBER(SEARCH("0",C2:C1677))+0)

 

[DanteAmor]

Try this

[FONT=&quot]=SUMPRODUCT([/FONT][FONT=&quot]SUBTOTAL(3,OFFSET($C$2,ROW(C2:C1677)-ROW($C$2),,1))*(C2:C1677=0)[/FONT][FONT=&quot])[/FONT]

 

[faraz502]

Thank you very much Sir, i got my answer finally. thanks again.

 

[DanteAmor]

Im glad to help you, thanks for the feedback.