jsk_lge New Member Jul 12, 2014 #1 I have a filtered list contains letters a, b, c, d etc. i want to count those cells only which contains "d". which function should i use?
I have a filtered list contains letters a, b, c, d etc. i want to count those cells only which contains "d". which function should i use?
N NARAYANK991 Excel Ninja Jul 12, 2014 #2 Hi , See this link : http://www.excelforum.com/excel-gen...only-to-visible-cells-in-a-filtered-list.html Narayan
Hi , See this link : http://www.excelforum.com/excel-gen...only-to-visible-cells-in-a-filtered-list.html Narayan
jsk_lge New Member Jul 12, 2014 #3 @Narayan dear Sir, I cant understand how to apply countif in subtotal ? like =subtotal(2,?,?,?,...) which function no. should i use and how apply the condition?? Last edited: Jul 12, 2014
@Narayan dear Sir, I cant understand how to apply countif in subtotal ? like =subtotal(2,?,?,?,...) which function no. should i use and how apply the condition??
Hui Excel Ninja Staff member Jul 12, 2014 #4 =SUMPRODUCT(SUBTOTAL(103,OFFSET(A2,ROW(A2:A100)-ROW(A2),0)),(A2:A100="d")+0) Adjust Column A and 100 to suit your data
=SUMPRODUCT(SUBTOTAL(103,OFFSET(A2,ROW(A2:A100)-ROW(A2),0)),(A2:A100="d")+0) Adjust Column A and 100 to suit your data