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

	ColumnB	ColumnC
Silver	South-2	3
Silver	South-2	3
Silver	South-2	3
Silver	South-2	0
Silver	South-2	3
Silver	South-1	3
Silver	South-2	3
Silver	South-2	0
Silver	South-2	4
Platinum	South-1	3
Silver	South-2	3
Silver	South-2	0
Silver	South-2	3
Platinum	South-1	3
Silver	South-2	0

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[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.